Lack of native support for SQLite in modern browsers is what is holding it back.
SQLite is exactly what WASM is good at, now the only thing holding SQLite/WASM back is a low level filesystem/block store api. But this is coming soon! It will enable so much more than SQLite too, you will be able to use custom SQLite builds with extensions, and other databases (DuckDB, MongoDB/Realm and others)
Turned out, every browser used SQLite as an implementation backend which lead to the deprecation of WebSQL.