Does SQLite really start choking? I feel like the issue is on configuration/ code side rather than on the database itself. It should handle thousands of writes per second, even on older Raspberry.

For this use-case, you can even likely implement own writer queue for every sensor type, and then batch insert them.