There can be many reasons for subdividing simplices, barycentrically or otherwise.
For a simplicial complex (triangulated space) there are the simplicial homology groups. These are known to be isomorphic to the singular homology groups, therefore (1) invariant under homeomorphism, and in particular (2) invariant under (not necessarily barycentric) subdivision. Before the invention of singular homology, I believe that (1) was unknown. Fact (2) was a key part of the theory. Subdivision is important simply because even if your space is made out of simplices you will sometimes care about subsets which are only unions of simplices after you cut the space up finer. In simplicial homology, excision is an easy algebraic fact, stemming from the fact that when a complex is a union of two subcomplexes then every simplex is in one or the other (or both).
In singular theory, as you know, invariance under homeomorphism is a triviality but excision requires some work. The point is that when a space is a union of two open sets then (bad news) not every singular simplex is in one or the other but (good news) simplices can be systematically replaced by combinations of smaller simplices to show that this does not matter. This is where subdivision is used, and there is no reason it has to be barycentric. It's like with the fundamental group: you might explore a space by using maps of a standard unit interval into it, but in proving the Seifert-Van-Kampen Theorem you might want to subdivide that interval into little pieces.
Barycentric or other subdivision also rises in PL (piecewise linear) topology in one other specific technical way that has nothing much to do with homology: regular neighborhoods. In a finite simplicial complex $K$, the smallest neighborhood of a given subcomplex $L$ that is itself a subcomplex does not in general have $L$ as a deformation retract, but this becomes true if you first barycentrically subdivide twice.
And in the interplay between categories and simplicial constructions barycentric subdivision turns up in various ways.