the thing I struggle to understand is those who voted Yes in 2014 were voting almost certainly to leave the EU.Nope it's banal and childish when people on both sides discount the polls that don't suit their narrative and push the polls that do.
Your example is purely twitter patter that both sides use (as recently as today by Murdo Fraser) when it suits
It only offers a suggestion that there should be a referendum (not actual independence) and it doesn't argue to change the rules of every major referendum ran in the modern era
I voted YES in 2014
So why is the EU such a big deal to you? I understand the upset to those NO voters from 2014 but you'd have happily dragged us out of the EU anyways