I know there were non-Catholic members who were part of Catholic families who contributed more to the parish than most of the Catholics in that parish. Music ministry being one place where they could contribute. And, contrariwise, I have a professional musician family member who made a living by heading up the music ministry for synagogues and a variety of Protestant churches. I can think of two Catholic churches he worked at-- one’s a cathedral, and the other was a large church that had a population in the tens of thousands.
That said, there’s a big gulf between Catholic music ministry and, say, Baptist music ministry. A lot of our Protestant brethren pay their musicians very healthy, whereas a lot of our Catholic parishes have miniscule budgets, if any, and rely mostly on volunteers.
So, if you were wanting to do it merely as a way to contribute, I think that would be great. If you were wanting to do it as a form of employment, though, I suspect that the majority of smaller Catholic parishes would be extremely disappointing.