> Some argue that the biblical passages against homosexuality are actually mistranslations
The Catholic position is that is not possible, for a few reasons:
1. The Doctors of the Church (a period of early writers from the first 300 years or so of Christianity), when they unanimously agree on an issue, are considered to be inspired by the Holy Spirit and almost certainly infallible. The discipline of the Church is to treat them, on unanimous agreements, as such.
2. 1 Corinthians 6:9 has Saint Paul explicitly stating that homosexuals will not inherit the kingdom of God. Maybe this is a mistranslation; but when Ezekiel 16:50 uses a word from Greek that means "sexually disgusting," Leviticus 18:22 remarks that it is an "abomination," and Jude 1:7 states that "Sodom and Gomorrah and the surrounding towns gave themselves up to sexual immorality and perversion," it's very hard to claim that all the verses were mistranslations. If that is the case, we may as well say that the Bible is not inspired and is not infallible - which would, quite literally, mean the Catholic religion (or any Christian religion) has no reason to exist.
3. If rape and inhospitality were the primary sin of Sodom; the men of the city would have been willing to take Lot's suggestion of using his daughters for their appetites. Lot was also an "outsider" in a cultural sense already - so it would stand to reason (as multiple commentators point out from ancient and modern sources) that if it was purely about violence to the stranger, Lot's offer should have been acceptable. The fact that Lot's offer was not acceptable shows the homosexual inclinations of the city.
With the above evidence, the Catholic position is that while inhospitality was certainly part of the condemnation upon those cities, it was not the primary cause. The alternative position is, correctly or not, a modern view to explain away the inconvenient.
Edit: Also, fun fact, there is a city that is in the correct place, dating back to the correct time, that appears to have been destroyed from an asteroid. There's no evidence to prove with certainty that it is Sodom, but that's because almost nothing from the city survives. Either it is Sodom or it inspired the story, but it's interesting. I can admit though that the odds of a massive asteroid perfectly landing on a city of only 8,000 people certainly seems divine.
https://www.smithsonianmag.com/smart-news/destruction-of-cit...
https://www.forbes.com/sites/ericmack/2018/12/04/new-science...
Edit 2: The Bible is infallible in the Catholic view. Vatican II explicitly stated: "The books of Scripture must be acknowledged as teaching solidly, faithfully and without error that truth which God wanted put into sacred writings for the sake of salvation." This does not mean that little historical or otherwise facts may not be different, so the term preferred on a technical level is inerrant.
https://www.vatican.va/archive/hist_councils/ii_vatican_coun...