Scotland doesn't currently want independence! (4-8% lead for No in polls in the last month)

If you're asking "Will support for Independence drop to zero" then the answer is no.

Some people will be swayed. Some people who are hoping Labour will make everything awesome will be disappointed. I doubt that the movement will go anywhere.