I had a look to see if I could find the "opposite" of this poll, and found this from 2021:
Three in four Americans (75%) say they would be somewhat or very comfortable learning a coworker is transgender. Nearly seven in ten Americans (69%) say they would be somewhat or very comfortable having a close friend tell them they are transgender. This percentage has gone up, from 63% in 2019. In addition, nearly seven in ten Americans (68%) say they would be somewhat or very comfortable learning someone in their church or faith community is transgender, and nearly two-thirds of Americans (65%) report that they would feel somewhat or very comfortable learning that a local elementary school teacher is transgender, up from 56% in 2019.
Via PRRI: https://www.prri.org/press-release/survey-americans-increasingly-support-transgender-rights
It's good to see the numbers are maybe not as bad as LGBTQ+ people think they are, although as a gay guy with trans friends, I can totally understand feeling that way. (I'm not American, mind you.)
I do wonder whether support may have dropped in the last couple of years โ the bathrooms/"women's sports" culture war feels newer than 2021 to me. ๐ค