Agreed, and that is why big countries should also be broken up. No more countries over 50m citizens. Many people in Europe don’t want the EU, but there’s really no alternative when competing with large countries like China and US.
You are the best kind of correct since "many" can refer to some large number that is also insignificant. The pro-European sentiment is vastly dominant, though, and that's what matters.