Adobe (Lightroom's file format), Skype (history/config), Airbus (flight systems), Firefox (data store), Google ("everything"), and more:
https://www.sqlite.org/famous.html
SQLite is everywhere. It is like the Linux of relational databases. If you aren't sure what your Smart TV runs, just assume it is Linux with SQLite as it is a safe bet.
Phone and browser installs don't count toward the popularity figure, because the users don't pick the DB that gets used there. The only time that choice counts is when the developers decide which DB system to use.
From a developer choice perspective, MySQL probably wins out more than any other open-source relational DB.
It may just so happen that software relying on SQLite makes it to the most consumer devices and software, but that doesn't mean SQLite is more popular than MySQL.