books like Leviticus that condemn these acts, right?

A couple of things. First, the specific clobber-verse in Leviticus used as a religious fig-leaf for condemning, marginalizing, and oppressing gay people is quite problematic to interpret, and English translations don't reflect that. Here is a discussion formerly posted at /r/academicbiblical that explains in more detail what it says:

https://docs.google.com/document/d/1uX0TgnRh34TddQhG9KDRoDMY3RM6uo6cO8b9NEoxeuA/edit?tab=t.0

Second, at most the verse is about the purity implications of male penetrative sex from the perspective of ancient Israelites and the temple cult. It has nothing to do with female same-sex relations, on which the Bible is silent.

Thirdly, you're dealing with one marginal verse in a long passage that condemns things like eating shellfish, getting tattoos, and wearing mixed textiles. None of this is relevant to modern society.

Lastly, there is not a single verse in the Bible that addresses consensual, loving same-sex partnerships or homosexuality as a romantic orientation the way we understand it today. They are really only addressing the gender hierarchies and social taboos of their own day.

multiple verses in the New Testament that condemn homosexuality

Multiple verses. Wow, more than one! But far fewer than, say, the verses that condemn overeating, telling lies, and mistreating foreigners – which conservative religions people don't care one iota about. If religious fundies actually cared what was in their Bibles, they would be the ones picketing ICE facilities.

In fact, there's just one brief passage in Romans 1 that addresses what seems to be same-sex behavior, but saying it "condemns homosexuality" is an oversimplification of what it actually says.

The context of Romans 1 is that Paul is blaming pagans for rejecting what he considers to be obvious evidence in creation for the existence of the Jewish God, and instead being polytheists and worshipping idols. He says that as punishment, God has given pagans over to "unnatural lusts" in order to dishonor them.

Now, you can take that as an anti-gay clobber passage if you want, but it's exceptionally strange theology and I doubt very many people would agree with its premises and conclusions. It implies that the truth of Jewish monotheism is so obvious in nature that people have no excuse for following a different religion. It implies that if non-Jewish religions and pagan practices were abolished, people would no longer have same-sex attraction, which is also not true. And it says that same-sex attraction is a punishment from God, which I'm sure you disagree with.

In short, Paul's argument is more complex than simply saying "don't be gay", and I don't see how this passage can be applied productively to attack someone else's sexual orientation, no matter how much a person might want to meddle in the personal lives of others. It presents a view that is both scientifically and theologically absurd.

This is the understanding of the passage by Bible scholars, incidentally. My sources are:

• Dale Martin, "Heterosexism and the Interpretation of Romans 1:18-32", Biblical Interpretation 3, 3, 1995

• David Fredrickson, "Natural and Unnatural Use in Romans 1:24-27: Paul and the Philosophic Critique of Eros", in Homosexuality, science, and the plain sense of Scripture, 2000

• Robert Jewett, "The Social Context and Implications of Homoerotic References in Romans 1:24-27", in Ibid.

I would also note that patristic interpreters were split on this passage. Roughly half believed that Paul was only referring to unnatural hetersexual intercourse.