Houston’s “gay rights” ordinance was apparently broad-based as to discrimination. But the Washington Post article by Justin Wm. Moyer says bluntly it failed for one reason: fear of men in women’s restrooms. Here’s the link. If if I were a transgender male to female, this would be a big deal, maybe.
The article gives a link to a useful chart, “The Christian evolution on homosexuality”, by Niraj Chokshi, showing a gradual improvement over time on the percent who say homosexuality should be accepted by society. Again, many religious and some secular nations (Russia) see homosexuality as a proxy for indifference to future generations.
Wikipedia attribution link for picture by “Hequals2Hemry” of Discovery Green in Houston