Even as the SNP celebrate, the party should recognise its popularity is on the slide and the need to fix the economy