I agree that interfaces like Datasette are a fantastic idea. But, it's not the same thing. Think of this more like the SQL standard. What would you do if SQL did not exist and there were no common ways to discuss querying databases?
There are a couple of problems I see with SQLite used as a common data format:
1. SQLite is a state machine that only stores the most recent version of mutable (binary) tables so change control is non-trivial.
2. Matrices/Tensors are not naturally stored in relational tables.