Nicola Sturgeon’s shock resignation was followed by collapse in SNP support, says pollster