But this is contrary to what is actually happening - when ElasticSearch changed to a "fair code" license, Amazon forked the last version and now maintain OpenSearch.

If you created a new project from scratch which is uniquely useful then sure, companies will probably pay. But what happens if a free competitor pops up? Or if one already exists? I don't see corporations paying for stuff they can get for free.

I dont expect to get paid because I use a certain license.

Then how are you expecting to get paid? It's not like with these licenses you would automatically get paid when someone uses your code. You still need to do non-trivial and non-development related work to form some business relationship with these companies