A huge surge in support to rejoin the EU has been recorded in October - has the bubble finally burst for Brexit and its backers?