Humza Yousaf’s SNP polling decline is ‘remarkable’ as no new leader bounce shows his unpopularity