There is a very vocal minority in the LGBTQ+ community and I dare say a larger number of people outside of that community rooting for this.
Most gay and trans people I have discussed this with feel it's unfair. I don't think we should tar them all with the same brush over this, it's just extremely vocal far left activists that are doing this. They have is so that people are scared to speak out about it.