Snowflake uses it: https://www.snowflake.com/en/blog/how-foundationdb-powers-sn...

Tigris uses it: https://www.tigrisdata.com/blog/building-a-database-using-fo...

A good collection of papers, blog posts, talks, etc.: https://github.com/FoundationDB/awesome-foundationdb

Snowflake article from 2018, I wonder if it's still true

The article is pretty vague, but nothing in it expired until at least 2023 :V

Yes. They hire engineers specifically to work on it.