I'm not in England but in mainland Europe and yes, I don't know a single person who sees Brexit benefiting the Brits. It was all lies and pandering for politicians benefits.
As an American generally uninformed on the manner, I only heard of pro-Brexit people in Britain.
The fact that they had literally no idea what would happen to Northern Ireland after Brexit tells you all you need to know about how well considered the idea was.
Part of this is down to the politicians who were running the show - David Cameron, the prime minister at the time, thought the referendum was a good way to put the issue to bed - you've had your vote, we're staying in, shut up.
He more or less directly said that they weren't going to make any concrete plans, because he thought the idea was so bad that they weren't going to spend the money on them, and because releasing explicit plans would probably just give ammunition to the 'leave' side. It certainly would have torpedo'd one of the major arguments of the 'remain' vote, which was that a vote to leave was a vote for uncertainty.
So in that way it was a self-fulfilling threat - you don't know what's going to happen because we refuse to make a plan!
> The referendum passed because people were largely ignorant of what Europe actually is
This too is a failure of politicians over several decades - the EU was always 'them', not 'us'. It was something that happened somewhere else. It was convenient to blame the EU when UK politicians couldn't or didn't want to fix something. MEPs were always pretty anonymous, unknown by local people who then (predictably) didn't turn out to vote in EU elections very much.
To the rest of europe brexit looks like voting Donny back in: the bicycle-stick-frontwheel meme. Except brexit was a bit more contained so easier to laugh at, Donny siding with the enemy in our biggest armed conflict is no joke.
How have those countries spun Brexit's failure? Just... "that wouldn't happen to US because we would be DIFFERENT?"
They always have like five taking points to whip their base in anger and it doesn't really matter what they are but they're always a bit lunatic.
In fact a lot of the sentiment tends to be more like "good riddance".