If you are a musician capable of this sort of workload, you'll be in demand.
Let's consider two important factors:
1.) Liturgical Needs
2.) Music Resources
Your average suburban Catholic Church just wants there to be music at Sunday Mass. Most congregations would prefer poor music to no music at all. This is why there is a plethora of volunteers with their guitars singing all sorts of sacro-pop.
What would be an interesting study is to see how many of the earlier hymns (percentage) talk about US/WE in comparison to those of today.
No, those are all prayers directed to God, not each other in the congregation.
To participate in the discussions on Catholic church music, sign in or register as a forum member, The forum is a project of the Church Music Association of America.