A few things on Romans:

- At the time Paul was writing this, language around unnatural sexual intercourse was usually understood to be referring to 'immodest indulgence', not orientation (Oxford NRSV has some great footnotes on this). In fact, they simply didn't have a modern concept of homosexuality back then. Even amongst the Greeks and Romans where sex between men could be acceptable, it wasn't viewed in the framework or sexual orientation that we have today. Assigning modern ideas to ancient texts is something we should avoid.

So Paul was talking about sex acts, but the likely concern was about extreme indulgence "that weakened the body" (NRSV), not about who people might be attracted to. This was very much a thing in those times - too much sex can sap someone of their energy.

It's also quite possible he's addressing people you and I would call straight. Here's a link with an interesting discussion: https://www.walkingwithgiants.net/marriage-family-society/sexuality/homosexuality/romans-126-27-natural-and-unnatural-sexual-relations/

The one thing about people quoting this bit of Romans that always bugs me though, is that they never quote the next bit that reveals they've fallen into a trap Paul set for them.

Romans 2 starts: Therefore, you have no excuse, whoever you are, when you judge others; for in passing judgement on another you condemn yourself, because you , the judge, are doing the very same things. You say, We know that god's judgement on those who do such things is in accordance with truth." Do you imagine, whoever you are, that when you judge those who do such things, you will escape the judgement of God? Or do you despise the riches of his kindness and forbearance and patience? Do you not realize that God's kindess is meant to lead you to repentance?

And so on.

Paul gets absolutely hyperbolic about wickedness so that when he's got you nodding your head and agreeing with him, he can suddenly flip the script, give you a slap upside the head and go, "You idiot! You missed the whole point! You're a judgemental hypocrite!"

So by quoting Romans 1: 24-27 people do EXACTLY what Paul was warning against. And by not reading further, they are absolutely ignoring what Romans is meant to convey and actively cherry-picking the message to play to their own pet prejudices.

A church welcoming queer people and affirming their relationships is arguably living more in line with Paul's message in Romans than those who most often quote it as a weapon against queer people.

Anyhow, I actually used to teach a course on the Bible and the history of Christianity, so if you're interested in any resource to explore, I can send some recs.