Where are the limitations of using SQLite in production for web applications? Here is a good list.

Definitely this. C++ isn't going away anytime soon. Rewrites won't be worth it in important cases, so improving the safety of the language matters.