Yeah, I'm a Catholic myself, and I've only ever met a few homo/transphobic in the parish, and the ones I have met are waaaaaay too traditional (my grandparents)
And before the homophobic Catholics come to say that it's in the bible that it's bad to be not straight, that was a MISTRANSLATION.
In the old days, only the priests knew Latin to read the Bible, and so they could make it into whatever they wanted and nobody would know.
Also there was a line in the bible with gay people and everyone was ok with it