Unfortunately, few in the Church at a level to be influential would ever answer the question because they wouldn’t want to “offend” either side.
What the Catechism of the Catholic Church says about homosexuality