SQLite is public domain while the code released by id/Carmack is GPL.

The latter technically doesn't prevent anyone making money off it, but in practice it does (other than nominal fees).

That alone is a massive difference.