A revote would mean that the cosmopolitan class will truly never take no for an answer and that the EU truly is Hotel California: you can check out anytime you like, but you can never leave. It would essentially mean that democracy in Britain is no more - not that it is presumably any better in other EU countries.
The UK, like any other member state, should be able to leave, but when you leave a club, you also lose certain priveledges afforted to members. The British government kind of acted like they could eat a cake and still have it, raising unreasonable expectations in the process and thus finding themselves in an impossible position, unable to satisfy any side. And I'm saying this as somebody who didn't want to see a "hard Brexit", as something bad for both sides.
Things turned out this way and both the EU and the UK have to go throught this. A re-vote wouldn't make things any better.