Backlash over Nicola Sturgeon's Cambo oilfield opposition hits SNP in heartland