Nic, that's a really good question. But I think some gay people who have faith in Christ and want to be accepted by a church are just like straight people. They may have been raised in religion or seek validation that someone higher loves them and made them the way they are. Although I'm gay, I'm not sure what I believe anymore. That's why I ask a lot of sincere questions and listen to the answers. I do not believe I know it all.
On the other hand, I don't see the "clear homophobia" in the Bible you talk about. At one time, people said the Bible was anti-black. Later, they said the Bible condemns mixed marriages. Others have said the Bible denegrates women. So this is what I did. I stopped listening to the voices of religious leaders and their followers, I ignored the traditions of the people of Bible times, and just focused on Jesus. It was then I realized that Jesus never put down women; he didn't insult prostitutes or those who were suffering from women's health problems. He got along with women great, and he trusted them more than some men, and they trusted him. (He appeared to women first, after his resurrection.) I also saw that he never used racism in his comments, although it was common at the time. For example, he never ridiculed Samaritans or gentiles like some of his Jewish opponents did, or as historians tell us was common at the time. (John 8:48: Jewish opponents attempted to insult Jesus by saying he was a "Samaritan and demon-possessed." Jesus denied being demon-possessed while ignoring the comment about being a Samaritan, not lowering himself to their level.) He was kind to lepers, something that was unheard of at the time. Also, he never criticized gays or lesbians, even though they surely existed. He doesn't even mention them; it wasn't an issue with him. When he said God loved the world, he meant everybody. John 3:16.
It seems that the Bible can act as a mirror. People who see hate in there, are really seeing what's in their own hearts, or at least in the heart of the person preaching to them at their church. That's my opinion, but I'm not sure what I believe anymore. But I do find it all very fascinating though.