Category theory in itself is pretty useless. Categories are a bit like graphs in that: they are too general.
There are serious mathematical theories using category theory as their language (mostly commutative algebra and whatever it touches) just as there are serious theories using the language of graphs, but in both cases the meat of the math is not in the underlying language.
If you want to research more about this, I can recommend sheaves in geometry and logic by Maclane and Moerdijk. You can also search for "algebraic set theory" and go from there.
And btw, type theory is essentially the same thing. The axioms are IMO uglier and more ad-hoc, but there are (some proven, some conjectured) equivalence results.
What about the following: https://ncatlab.org/nlab/show/foundation+of+mathematics#CFM
Even if the meat of the math is not in the categorical aspects of a theory, the categorical input can be useful - if nothing else, then as a convenient language.
When you’re working with structures (algebra, geometry, topology, etc), sure, you can construct them in the language of categories. But that’s very far from “all of math”.
It's certainly very abstract and fundamental, but it's definitely not the root field.
Category theory is not a great basis for mathematics, but at least it's not inconsistent.