I would argue that this value capture was the goal all along. I saw it coming from a mile away, and I expect it to get far worse.
Your content is amazing and you're just putting it out there for everyone to see. I hate to say it, but if I were you I would go the Patreon, etc route and have some basic information on your free tier - enough to keep some traffic - and work with paying customers. This might require some changes in the way you work but I feel you are already well-connected and liked and have built a healthy community. I think you will get 80% of the benefit for the community and you get to keep doing what you love.
You'll be the Berlin-guy and accessing your information in full will only be $1,99 for the "Pro" tier and $4,99/month for the "Deluxe". I'm only half-joking. I think it's time for people to start putting a premium on everything especially their time because the corps ain't giving freebies and why make them rich?
The government cannot build, buy or maintain anything like my website. It's not that I am so incredibly awesome that they can't match my work, but they operate under a very different set of constraints. They'd rather burn a million euros on a dud than bankroll one guy to do whatever seems to already work.
I have many helpful contacts in that area, and they all seem to agree that the government/grant approach is not worth it.
On the other hand, I would love to work for them if I am forced to get a job again. Some parts of the administration are really cool: CityLab and Digital Service for example.
If serving me ads brings you 100 microeuros when I read a page on your side, i don't mind paying this. The problem is that there is just no service with which I could send them to you. Same is with news, forums, reddit or whatever.
I have built a lot of infrastructure to surface that information. I've set up group chats, built relationships, and created tools. Now all that work just feeds the AI that is putting me out of work.
By December next year I'll probably have to put the website in maintenance mode and find another job. The problem is that AI also made software development absolutely fucking miserable. At least I have savings, but if this whole AI thing fails it will also tank the economy.
I won't lie, it's devastating.
https://nicolasbouliane.com/blog/death-by-ai