I think that what's really going to happen is that this will goes the same way all these independence movements go, they'll vote to remain in the end. It's one thing to imagine yourself as independent and I can see how it might be appealing but taking a step over the edge into the realm of uncertainty is not a comfortable or very human thing to do.
And that's exactly why it is likely to push for it. And given that there's a solid pro-EU majority in parliament, it's likely that getting a deal as comprehensive as possible with the EU will be high priority, similar to how it was for Norway after the no vote in the referendum, where the EEA was used as a "consolation price" by the pro-EU parties.
They will argue that they have a strong mandate to do so, given that the Leave campaign have kept bringing up Norway as an example of how the UK can do fine outside the EU...
I do hope the UK votes to remain - I'm Norwegian, living in the UK. Though it won't affect me personally that much, as I qualify for leave to remain under at least three different categories. I agree with you that a good chunk of voters will end up voting remain even if they may be thinking of leaving now. The question is just if it will be enough.
In the case of Brexit, I predict a rush from the pro-EU contingent in parliament to get an EEA style deal in place before the next elections.