I'm trying to figure out what you mean. Experts forecast Brexit would hurt the financial sector, Northerners said they were cool with that, the forecast was wrong, Northerners were upset. Nothing about that sounds illogical. Vindictive and short-sighted, sure. But everything follows reasonably.
I say this as someone who's stomach sank when I'd heard that Brexit had passed and that there was a real chance that Donald Trump could be elected.
A lot of voting, Brexit and other stuff, comes mostly to whether people are pissed off with the current situation or not. If pissed off they vote for a change as in Brexit, otherwise not. I'm not sure a lot of the reasoning gets much deeper than that.
I remember asking Brexit voters who said they didn't want EU regulations to name one actual regulation that inconvenienced them and I don't think I got one answer.
That's fine, but "Brexit voters were generally irrational or misinformed" does not change the fact that this particular case features Brexiters who voted cynically for an outcome that they were assured would happen by the very people who were seeking to prevent Brexit, who were then justifiably upset when those predictions didn't come to pass. It's not a good example of the irrationality of Brexit. Maybe of the futility of attempted revenge.
I say this as someone who's stomach sank when I'd heard that Brexit had passed and that there was a real chance that Donald Trump could be elected.