I don't think the vast majority of fans care either way to be honest. People are not as narrow minded on the whole and often drawing attention to things like this just makes people irritated by its over exposure. We have moved on in society, thankfully. and often the media like to promote the message that we haven't. A dramatic, exaggerated story will sell more newspapers than a real one.
Does a family living in Loftus, or a kitchen sink estate in Boro, spend time discussing whether a footballer is gay, trans or bisexual ect? Probably not as they are more concerned with where the money is coming from to pay the rent or put food on the table.
I think this was exemplified in an article I read in one of the newspapers at the start of the covid pandemic. The page was full of stories of suffering, death, predicted death, and the concern expressed around finding a vaccine. At the bottom of the page there was a small piece describing the singer Sam Smiths 'ordeal' and 'anguish' around opening up about his sexuality.
It felt to me like it had been put there to highlight something there was enough awareness of. It seemed out of place at a time when the country was worried about its future and rising death numbers due to a pandemic.