Most voted for it.
If you're in a vacuum chamber that's your problem.
Of those who voted, a very small majority voted for it. By no means most British voters voted for it.
A reprise of the vote now would not secure the same outcome.
Most of the european resentment comes from that fact. Most southern european countries were taken for a ride during those negotiations, and have paid (and continue to) a steep price.
I was a strong believer in the common currency but after reading about it for a while I'm not convinced it was a good idea anymore - if you're anyone except Germany or France.
Paul Krugman wrote at length about why that was a mistake, and he was 100% right about it.
So if the UK had joined at the inception, it would have started as a common currency, but when the UK decided not to join, it reverted to the preferred form of some of the other members, namely the "single currency".
I imagine that the rules would have been different with a common currency, possibly with the national currencies not replaced, and still operating in tightly tracked bands; but I guess the UK fate there was written when it dropped out of the ERM as part of "Black Wednesday", caused by it entry peg being overvalued.
So a common currency may well have allowed for more north vs south flexibility...
Edit: cheap Russian gas + high productivity + political stability + undervalued currency (the Deutsche mark would have been way stronger than the euro) is what fueled German dominance in Europe. Italy/France/Spain/Greece/Portugal all struggled with varying degrees with low productivity, political instability (apart from France) and a currency that was too strong for their macro-economic fundamentals.
Ultimately, Germany succeeded better because they acted better and more productively.
>President François Mitterrand argued for the single currency because he hoped to bolster French influence in an EU that would otherwise fall under the sway of a unified Germany
https://www.economist.com/leaders/2012/11/17/the-time-bomb-a...
The Economist in the 90s was pro single market: https://www.economist.com/leaders/1997/03/13/single-market-s...