There’s a small percentage of the population that very strongly leans towards attraction to the same sex with little or no attraction to the opposite sex. Most everybody else is varying degrees of bisexual with a strong preference towards the opposite sex. With a Christian lifestyle any latent attraction that might exist with the average person towards the same sex will remain undeveloped, but a promiscuous lifestyle will and does create a lot more people who are actively bisexual. This is called “chasing the dragon” in the world of drugs and the same principle applies to sexuality. As barriers go down and people look for more and more thrill to try to make sex exciting, they are willing to do more things.
So sexuality is to some extent malleable for the general population, but as far as those people who are very strongly SSA, there’s no evidence that any kind of conversion therapy will make them do a 180 and suddenly be straight.
In past centuries, when sexuality was more taboo, homosexual people usually just got married like everybody else and had kids anyway. This is how it generally worked for the past 150,000+ years. I remember a gay person who was married on another forum telling me that he doesn’t find vaginal sex repulsive or unpleasurable, but the actual attraction wasn’t there. He loved his wife as a person, but he was sexually attracted to men. I’m not sure how possible this would be in the 21st century which is much more hypersexualized than any previous generation. It seems dishonest for a husband or wife not to tell their spouse about this.
So for therapy, I think productive Catholic therapy would be more about living as an SSA person, finding purpose, happiness, etc., versus trying to become straight. Anything that will actually change a person’s sexuality in the future would probably be based on gene editing or other techniques that affect physiology.