The priesthood was an attractive vocation for gay men before the sexual revolution However, the Bible, the saints, the constant teaching of the Church, and the downward spiral of cultures and churches that normalize these things provide ample evidence to faithful Catholics that the Church needs to stay true to its timeless teachings on human sexuality and family. If these were not sins there would be no need to make an effort to preserve the Church's teaching. There is not much mainstream debate on these topics anymore and many Christian denominations have followed the culture, only to see their congregations diminish. The Catholic Church has been under strong pressure to follow western civilization and normalize moral issues such as homosexuality, contraception, abortion, sex before marriage, sex outside of marriage, divorce, porn and masturbation, etc. However, the priesthood is not a job, it is a vocation, with very specific criteria laid out by Christ himself.
The Catechism of 1992 is clear that there should be no 'unjust discrimination' against people with same sex attraction. This is part of wider discussion about the nature of the priesthood and the nature of sin.
