Yeah that project is pretty interesting, I probably wouldn't rely on it for pipeline work yet however since it's so new.
If you are set on Git, then it did recently gain more support for large files which is based on an older and seemingly stable basis called "git annex".
But I'm sceptical as to whether Git is the right approach here, since the Git methodology is "clone everything" which can be difficult when your asset library is in the terabytes range. SVN, Perforce and the like are on the opposite side of the fence, "clone what you need", which I think might be better suited for out kind of work. But I don't know of anyone who has actually tried and I'd be interested in seeing what benefits lie therein, as I'm sure there are many (maybe more than there are downsides!)