The question as posed paints with very broad strokes. I’m guessing by “religious people” you’re probably thinking of American christians of the larger denominations.

Why do you think that religiosity is necessary to oppose queer people? In my experience, opposition to the queer community and expressions of queerness is tied to views on gender and conservative/regressive views overall. While there is certainly overlap between orthodox/regressive religiosity and said roles, you can still see a lot of bigotry from people who don’t care about what any god says, they just think “that limp-wristed fairy isn’t a REAL man”.

As with anything outside the mainstream, the experience of being an atheist (and being “out” as an atheist) can lead people to question more things that are considered normal and empathize with others, but it isn’t a given.

Sometimes deviance enforces a sense of humble and earnest examination of common truths and connection with others and their own struggles, and sometimes it enforces the view that this person knows better than the crowd so no need to really question what is definitely their own views.