The SNP leader badly miscalculated his support. But London’s meddling in Scottish politics also played its part, says writer Rory Scothorne