How wrong you are.
The Roman Catholic Church does NOT approve the ordination of "active" homosexuals to the priesthood. The church has consistently taught that homosexuality is a disordered state. ALL catholic priests must abide by a vow of celibacy. Those homosexuals who infiltrated the church did so through concealment of their SSAD.
"In recent years, various questions relating to homosexuality have been addressed with some frequency by Pope John Paul II and by the relevant Dicasteries of the Holy See.1 Homosexuality is a troubling moral and social phenomenon, even in those countries where it does not present significant legal issues. It gives rise to greater concern in those countries that have granted or intend to grant legal recognition to homosexual unions, which may include the possibility of adopting children. The present Considerations do not contain new doctrinal elements; they seek rather to reiterate the essential points on this question and provide arguments drawn from reason which could be used by Bishops in preparing more specific interventions, appropriate to the different situations throughout the world, aimed at protecting and promoting the dignity of marriage, the foundation of the family, and the stability of society, of which this institution is a constitutive element. The present Considerations are also intended to give direction to Catholic politicians by indicating the approaches to proposed legislation in this area which would be consistent with Christian conscience.2 Since this question relates to the natural moral law, the arguments that follow are addressed not only to those who believe in Christ, but to all persons committed to promoting and defending the common good of society."
CONSIDERATIONS REGARDING PROPOSALS TO GIVE LEGAL RECOGNITION TO UNIONS BETWEEN HOMOSEXUAL PERSONS
however, many years ago the Catholic Church revised their thinking to state that marriage ( and sex , naturally) were for procreation AND the mutual enjoyment of the couple....
and did you know that there are some men who are priests that were once married, and have grown children?..