The Catholic hierarchy and vast numbers of Catholics have been overtaken by modern notions of sexuality and sexual identity. This runs completely counter to the Catholic understanding of vocation. There are three: married life, religious life, and single life. Everything else is subservient to the three vocations. You fit into one of those callings, and everything else is irrelevant.
Over time, and this took time, I dropped Freud and psychology as a helpful way to understand people. All of it caused us to become obsessed with sex. The law of attraction is always at play. God gave us that. However, unless you are in love with someone, you need to let it die. I do, even though most people think I don’t. Their misconceptions about me cause me to withdraw from society regularly.
This comes about because some people are narcissists and think too highly of themselves.