The point is that the community at large was willing to accept these people as role models for their children and did so with minimal hostility or interference (visible anyway, since I can't see what happens behind closed doors). Entrusting a teaching position is a little different than any other random job.
While I'm sure there are horror stories, in practice it would be very rare to find someone who was legitimately "fired for being gay".
The myth that Republican areas are hostile wastelands with poor quality of life for minorities has much more to do with confirmation bias and a desire to justify high cost of living than anything else, IMO. This is not to discount any personal experience you may have had, just my opinion on the sentiment in general.