This comes about from their development styles (see: http://www.catb.org/~esr/writings/cathedral-bazaar/).
- Use fossil if you prefer the cathedral style of development SQLite is open source but does not accept contributions.
- Use Git if you prefer the bazaar style of development. You want to accept hit-and-run style contributions from anyone.