Well the big difference is that an sqlite db has to be running. Git repos just exist as long as the files are on disk, which I think is a mental model people are very used to by now.
Sqlite does not have a server component (although there may be other projects that do provide sqlite as a server). Sqlite files are also just files on the disk.
No, the whole magic of sqlite is that it is also just file-on-disk.