A subset of the EU needs to go federal, with the remainder staying in a toned down version of the EU.
Do you think the national governments are more connected to the local population? I'm sure the Polish and Hungarian population think that
"Boo EU bad" has become a meme already. Yawn
The UK is the extreme example of this: for a decade, their EP contingent has had a massive number of euroskeptic politicians who never managed to win more than a single seat in the British Parliament. Brexit proved that Strasbourg was actually more representative than Westminster.
The definition of federal: "Of or constituting a form of government in which power is distributed between a central authority and a number of constituent territorial units"
OP is suggesting a more decentralized EU, not a "bigger leviathan"