I think the problem is going to come with the divorce settlement.
The UK wants all the benefits that come with the EU membership like preferential trade deals etc but doesn't want to share the workload of financially assisting the weaker member states via EU membership fees and helping with the migrant and refugee problem.
The EU obviously needs to nip in the bud any ideas of other member states exiting and isn't going to allow the UK to walk off into the the sunset with a handful of newly negotiated trade agreements without very large commitments and concessions from the UK regarding refugees and other thorny issues.
The way I see it is that everyone has their own agenda (politicians, MP's, business leaders etc) and will lie through their back teeth accordingly. The only exception is the stock markets, they have an agenda but at least it's a transparent one and they don't lie, they just react. When the world markets shed trillions in value at the prospect of the UK/EU exit it's a sign that doesn't bode well for either party in my opinion.
If the UK ever had a time where it needed strong and focused leadership, that time is now. If there was ever a time where the UK would benefit from a united front from Scotland, Ireland and Wales, that time is now. Unfortunately at the moment it has neither.
I suspect the UK won't want to negotiate with the EU on the issues such as refugees and EU isn't going to give the UK any meaningful trade agreements. The UK economy will suffer at least until it finds new trading partners or possibly until the EU starts falling apart, neither of which I'd hold my breath for.
I think in the longer term the exit may well be an advantage to the UK but I see a rocky road ahead at least for the next few years and maybe longer. So in answer to your question I also think that another exit referendum vote maybe in a year, after the divorce negotiations haven't been as fruitful as many had hoped for and a little of the negative economic impact has been felt, might well give a different result.