In your church, if you have somebody who had a sinful past and wants to repent of that, you tell them that their sin is unforgivable and that they are unwelcome, if that sin they repent of is homosexuality.
If that sin is ongoing because of continuous homosexual thoughtso even if no alleged actions, it’s kind of hard to ever get over the sin, isn’t it. Perhaps then that person would be better suited to leave the Catholic Church and join the Episcopalians where he/she would be more welcome.
On a doctrinal level, encouraging such a person to join the Episcopalians would be similar to condemning the person to Hell, as the 'piskies would just encourage them to act on their urges, while the Catholic Church would encourage them to learn to pick up their cross and follow Him (Mt 16:24 Then Jesus said to his disciples: If any man will come after me, let him deny himself, and take up his cross, and follow me.)
On a practical basis, in many (most) parishes, the subject sadly doesn't come up. And I can just see liberal heterodox Catholics citing this MSM account to say that the Church has changed its position, when nothing of the sort has been changed.
Repenting means being forgiven and then going about the rest of your life having done penance and not revisiting the past occasion of sin.
Having received absolution from God through the confessor does not mean that there is not still some atonement due for a grievous sin.