I've been using SQLite in a desktop product for around 10 years, and I guess there are around 1-2k deployments of it.

Therr have been a couple (literally) of occasions where customers have contacted me and it turned out their database was corrupt, though I don't know the circumstances under which it occurred. Presumably there are instances where it wasn't reported to me too.