If I'm honest I think on the whole most people don't care that much if a character is queer as long as they're written well.
There are some younger LGBTQ+ people (as in just realising that they are, not necessarily in age) who will love and need those characters because they are queer and help them feel less alone, especially if they aren't in an accepting environment. They are also usually the people who will say "watch this there's a gay person in it" and will watch things for that reason, because they need to not feel alone.
There are people who have made their whole identity hating what is different who will post homophobic slurs about even the smallest queer bit-part. They are just hateful people who have decided that queer people don't deserve to live, and I don't think their view should be taken into account for this reason.
But on the whole, people will just accept a queer character the same way they accept any other character. If it's the first person of that group they've seen, they might go "oh, different, I didn't know that was an option" but still enjoy the story. They won't promote the story because of the queer rep but they will promote the story for being good.
Like I recently watched The Sandman and I was surprised by how many queer characters are in it because I'm used to being a baby gay where people shout "LESBIAN CHARACTER IN MEDIA" at me. Some of the characters were also queer in the original comic from 30 years ago which was also surprising.
People told me to watch the show because they thought I would like it and it's good, so I got to go in and find out that people love this show where there's bi characters, and gay characters, and lesbian characters... My favorite character design on the show is Desire who's explicitly non-binary and played by a non-binary actor, and despite being a villain I really like them because of the chaos they bring to the story.
There are still a tonne of stories with no queer people, and a tonne of stories with a lot of queer people, and some in-between... That's kind of what I want us to move towards, where it's not "queer rep" it's "queer characters" because they're normal to have, like female characters, and characters of colour, characters with disabilities or neurodivergent characters. Get to the point where it's ok if one author gets it a bit wrong because there are millions of stories that get it right and that author isn't going to be someone's only impression of that group of people.