John 3:18 Whoever believes in him is not condemned, but whoever does not believe stands condemned already because they have not believed in the name of God’s one and only Son.
While St Augustine was working on his book "On the Trinity", he was walking by the seaside one day, meditating on the difficult problem of how God could be three Persons at once. He came upon a little child. The child had dug a little hole in the sand, and with a small spoon or seashell was scooping water from the sea into the small hole. Augustine watched him for a while and finally asked the child what he was doing. The child answered that he would scoop all the water from the sea and pour it into the little hole in the sand. ‘What?’ Augustine said. ‘That is impossible. Obviously, the sea is too large and the hole too small.’ ‘Indeed,’ said the child, ‘but I will sooner draw all the water from the sea and empty it into this hole than you will succeed in penetrating the mystery of the Holy Trinity with your limited understanding.’ Augustine turned away in amazement and when he looked back the child had disappeared.
If you love God, you must reject the ungodly, whatever it's manifestation, sexual or otherwise. Consider the examples of Ananias and Sapphira, Lot's wife, or Onan. They each held back "only a little", and each perished nonetheless.
We all have sinful temptations, it's part of out fallen nature. But we must be working to overcome those impulses, not embracing them. Sexually speaking, the purpose of those organs and those acts is to reproduce. We know this because that is the natural outcome of the acts. Therefore, those acts are Holy only within a Sacramental Marriage and open to the possibility of children. Acts outside of those conditions are sinful, be it adultery (sex outside a marriage if you are married), fornication (sex outside a Marriage), sodomy, onanism (including birth control methods of any sort), etc...
So a man might be attracted to a woman other than his wife (completely heterosexual) and still not go to Heaven. Or be using a birth control method with his wife and not go to Heaven,
Galileo was celebrated for his discoveries. But he became arrogant, demanding the Church declare heliocentrism right despite not being proven by Jupiter having rings. (Generally accepted "proof" not coming until the 18th and 19th centuries with demonstrable observation of the Parallax View.)
What got Galileo in trouble was his obnoxiousness. Since Copernicus proposed heliocentrism a generation before, it was a raging debate among astronomers, none "persecuted" for holding those views by the Church.
