I don't get that at all. To me the answer is "we want things out of the vcs that we don't get from git nor github/gitlab."

The fundamental difference is: sqlite is a cathedral, git is for bazaars. That's kind of a big deal.