Fossil is used by SQLite (who created it) and until recently Mercurial was used by Facebook but that's about it.
Aside from Facebook and Google who have their own custom VCS's the only real games in town are Git and Perforce. Which is a bit of a shame because Git is really bad at some things. Especially large file support (hence Perforce continuing to exist), submodules, and partial clones.
