Maybe SQLite isn't that big, but Red Hat makes billions of dollars of annual revenue. GitLab is a public decacorn (or was one yesterday, anyways). Those are good businesses, and I'm pretty sure a good chunk of us run software from both of these.

It’s a one man company run by Richard Hipp.

Big enough to keep the developers happy to keep working on it. That is all that matters.