I have just read some introductory stuff about Category theory, and while I understand what a category is, and some examples of it, the purpose of category theory is still vague to me.
It seems there are three frameworks for mathematics:
set theory
type theory
category theory
In practice, people don't do math in set theory, because it's unnecessarily technical, and not very helpful. Type theory seems to more closely capture the way mathematicians intuitively think in practice than set theory.
But I'm very unclear about what it means to "do mathematics in category theory". What does this mean in practice? How does a mathematician who "thinks in categorical terms" approach math differently from one who does not, and why?
This is a very tricky question to interpret and to answer, but don't get me wrong, I like it.
I think that one implication here is that certain mathematicians might view all of mathematics through one of these theories, but I don't think anybody really does that. I think these theories serve as foundations for large subfields of mathematics though.
Philosophically, category theory does seem to be a natural mathematical language, as it reduces everything to the study of objects and relations between them, and that sounds like a good description of what mathematics is at its core.
If you want an example of somebody using category theory for a reason other than aesthetics, I would suggest looking at modern algebraic geometry. Grothendieck built much of the formalism there on category theory due to his so-called "relative point of view" (see here). Adopting a category-theoretic description of algebraic geometry and using universal properties and functoriality to solve problems is way easier than working directly with algebro-geometric objects in the classical setting. Vakil's notes (here) even begin with category theory, setting up the language and style of argument for all else that follows. They give a decent justification of why category theory is so useful.