Eh ... the UK Right such as Farage will just keep shitting on the EU constantly with Farage staying in power as an MEP forever with the brexit deadline forever being extended. All the while nothing gets done, and the Eu has to keep dealing with the UKs instability and constant whining. It is the same tactic Poland and Hungary's politicans have been using to stirr shit up for many years, and the EU does nothing to defend itself as a political entitiy.
Not generalizing, but in the end the UK will not do a second referrendum to fix this. If a large economic block is being dragged down by a member that wants to leave , and keeps threatening with leaving no deal and never actually does it either :
A) cancel Brexit
B) kick them out, so they can finally play ther nationalism game and freedom they want so much. ( to privatize and fuck over citizens as much as they can without oversight)