As for my information, I find this to be fairly straight forward.
1stCor 6:9-11
9 Dont you know that evil people wont have a share in the blessings of Gods kingdom? Dont fool yourselves! No one who is immoral or worships idols or is unfaithful in marriage or is a pervert or behaves like a homosexual
10 will share in Gods kingdom. Neither will any thief or greedy person or drunkard or anyone who curses and cheats others.
11 Some of you used to be like that. But now the name of our Lord Jesus Christ and the power of Gods Spirit have washed you and made you holy and acceptable to God.
I applaud the statement of the Catholic Church, considering it's pedantic and should be shouted at any follower who even considers wandering astray of the admonishments. Of course there is no room for homosexuality amongst those who follow Christ, let alone leaders amongst the Church. There's no need to even discuss it. If somebody wishes to come to Christ, the door is open, not for a bartering session on the impact on the Church unless we sortof ignore sins which specifically are outlined in Scripture for us to resist.
God isn't so weak that He must rely on a portion of the Church, if it slips away in order for Him to fulfill His plans. However, the Church as a group might be in for some serious Divine Discipline which otherwise might only be reserved for the unrighteous, if we continue to acquiesce to homosexuality in such a luke warm fashion.
Surely there are believers and baptized believers who go to hell each day. They have effectively rejected the sacrifice of the cross and chosen to reject salvation. That ought not to be a cause of joy to us whom God enjoined to love those sinners. That they would be punished in hell must be just otherwise God would not so punish them. When Jesus Christ ordered his disciples to go forth and teach all men, he even meant the ones we do not like or whose sins we find loathsome. Mother Teresa was as good an example of the love of God in action as I have seen or expect to see in this life. May her loving faith and obedience to God be a beacon to us all.