Why does SQLite (in production) have such a bad rep?

it doesn't?

if you are referring to issues using sqlite as a production database for large-scale web applications, I would remind you of the phrase "horses for courses".

https://sqlite.org/whentouse.html

doesn't expensify use sqlite in production?