Using the bindings is only possible if the library itself is already installed (since the bindings directly make use of the library, under the hood).
I imagine this is because SQLite is VERY easy to bundle with Python itself. So on some platforms the OS SQLite is used, but on others it gets shipped as part of the Python installation itself.
It even works in WebAssembly via Pyodide!