https://internetdb.shodan.io is powered by a SQLite database and gets millions of requests a month. It does require a different workflow and custom synchronization scripts but otherwise it's performed well.
These sound like the kind of hidden costs that could turn sqlite's simplicity quite complicated if you don't see them coming.