Ah but look closely at those votes - do you see anything strange about them? Anything at odds with the idea that they are being cast by directly elected heads of government based on national policy programmes?
Edit: Nevermind, I'll be more direct.
What you linked to isn't the European Council that has elected heads of state in it. It's the votes of the Council of the European Union. Yes, this naming choice is astoundingly stupid, and because it's never been fixed despite many decades of confusion there are many who speculate the confusion is deliberate. It creates exactly the kind of false appearance of democracy that's tripped you up here.
The European Council, the one with Macron, Merz, etc in it, doesn't publish anything about their decision making process. There probably aren't votes. They don't approve or disapprove laws, either. Officially they decide things by consensus. Unofficially nobody knows because they all swear each other to secrecy.
The laws are approved by the Council of the European Union who are, theoretically, still ministers from the different governments i.e. a vote on a trade law would have trade ministers. In reality, that's not how it works either. You can easily verify it. Here's a random law that got approved recently by the 'democratic' parts of the system, on "the welfare of dogs and cats and their traceability":
https://data.consilium.europa.eu/doc/document/ST-9729-2026-I...
Obvious questions one might ask include:
1. Why does dog welfare have to be imposed on members via transnational law they can't change?
2. Why are nearly all the votes of the Council passing with 95%+ support, all the time? Aren't they supposed to be from different political parties in different countries?
3. Is it really plausible that elected trade ministers from all over Europe travelled somewhere, met and had a meaningful debate about dog welfare?
The answers are respectively:
1. It doesn't and shouldn't.
2. Because they aren't real votes.
3. https://agenceurope.eu/en/bulletin/article/13873/27/eu-counc... says "The EU Council adopted the regulation ... without debate." (note the same naming confusion in the EU's own websites - they use "EU Council" to mean the body that approves laws, which isn't the body made up of heads of state that calls itself the European Council).
This law was waved through by some low level civil servants on behalf of the ministers. Probably neither group even read it. As is true for almost all EU law: most of the work is done by lobbyists.
So, when people tell you the EU is a democracy because of the Council, think about that. Or just ask them which council they mean, because they probably don't know themselves. Fun fact: there's also the Council of Europe which isn't connected to the EU at all.