I think the massive difference is the number of people using the project vs. contributing to the project. How many people contribute to SQLite vs the Linux kernel. AFAIK not many for the former.
In other words: its use of any specific VCS is pretty much irrelevant.