To provide a non-medical perspective:
The Church does declare that homosexuality, whether the inclination towards or act of sex between two men and two women, is seen as disordered (CCC 2357-2358). However, this isn’t exclusive to homosexuality. For instance,
here is the CCC entry on the Sixth Commandment (Seventh for Protestants). If you Ctrl-F “disorder”, you’ll get it three times before even reaching homosexuality (twice for lust, once for masturbation) and twice after (both for divorce). I think CCC 2351 best describes why all of this is disordered:
2351 Lust is disordered desire for or inordinate enjoyment of sexual pleasure. Sexual pleasure is morally disordered when sought for itself, isolated from its procreative and unitive purposes.
In other words, we judge based on how God originally intended our sexuality to be - loving, unitive, and procreative. We can also include “between man and woman” given Jesus’ comment in Matthew 19:4-5 and Paul’s discussion on marriage in Ephesians 5:21-33, with particular emphasis on verses 31-32.
Anything that violates this is considered disordered. This includes masturbation, contraception, lust, adultery, etc. And yes, it also includes homosexuality. But in all cases, our job as Catholics remains the same: Call people to a higher standard, love them whether they live up to it or not.