>It's quite telling even the most pro-EU people are very opposed to creating anything resembling a real country.

I am both of those things and I am not sure what it is telling you?

>Once it's dissolved or enough countries quit,

There was quite a strong anti-EU stance here in Denmark until Brexit. As things are now, suggesting Denmark leave the union is political suicide. I imagine that trend is similar in other countries.