Another referendum now would have a similar result to 2014’s. YouGov’s polling shows that Nicola Sturgeon faces a tricky task in turning things around