And many mobile apps do. In such cases, SQLite is merely used as a serialisation format for nonconcurrent applications (like JSON but better tailored to the relational needs). That's a huge productive "market" for SQLite.

As others have said, SQLite can also cope with a server load. The website of SQLite has great documentation about that, too.