The whole debate was bad-faith, dishonest and identitarian. On one side you had plenty of jingoism and EU scaremongering, and on the other plenty of snobbery and class hatred alongside the most hagiographical eulogising of a very flawed and undemocratic, ideologically motivated bureaucracy that has a stated goal of taking ever more power and control.
Some people benefitted from the EU as they could get artisan candles from Italy, holiday in Tuscany and could benefit from the exploitation of cheap immigrant low-skilled labour, and cheaper immigrant tradespeople. Fortunately, the cheap immigrant labour didn't move in next door to them though or affect Charlotte and Toby's schooling. Supporting the EU also fed into their 'cosmopolitan' identity and made them feel they were 'on the right side of history' in an uncertain world.
Other people had far less clear benefit. As we see now, wages in certain industries were suppressed and corporations exploited cheap labour rather than offering better terms and conditions. The same people who had their wages suppressed also had to deal with the consequences of large scale immigration into their areas, pressure on schools and housing, etc. "Progressives" then told them if they complained about this then they were stupid racists because the EU was obviously very good indeed.
While obviously this is a simplification, it is also approximately true for many people.
Humans are emotional, over the years the smug contempt of the progressive intelligentsia, those on social media, etc. did far more to boost the cause of Brexit than the lies of people like Farage. It wasn't 'right wing media' that fractured the traditional left wing alliance of the working class and urban progressives, but changing values among progressives. If progressives call people stupid, backward racists enough times and show they care nothing for their experiences, it's not surprising that they aren't exactly lining up in support.
Politically and economically I see it as bad long term. We voluntarily left the world's largest trading bloc for some Little England reactionary fantasy. I judge it on both - the politics and the economics.
We'll see. My guess is that the EU won't survive long term, at least in its current form, so the debate will prove academic. The timescale depends on continued success, as I doubt it can withstand too many sufficient sized crises that pit member states against each other (the last GFC was one such event, and it showed quite clearly that many within the EU cared more for protecting the Euro than helping the citizens of Greece).
For all the bemoaning of how 'racist' Britain is, most EU countries have far higher levels of support for actual far-right parties (France, Germany, Austria, Italy, Greece, etc.) and the EU is a significant factor in this, and as an institution, it seems incapable of learning from its mistakes regarding 'ever closer union' and unaccountable, technocratic nature.
Maybe the fantasy will end up being that of the liberal internationalists. Time alone will tell.