I think it's a double-edged sword.

On the one hand, it can be a motivation for people who are homosexual themselves, Or it can be a role model as someone else already said in the comments. And it might be a wake-up call for one or the other rather 'conservative' thinking person.

On the other hand though, something like this shouldn't be a big media attention thing. He's gay, that happens, who cares. That was basically my reaction, but that also implies that for me homosexuality is as common as heterosexuality. So in this sense, a who-cares-reaction might be a positive thing. Sure, there might be people are sincerely desinterested, but I think a big part of the who cares sayers has accepted homosexual people as part of the society just like heterosexual, so this news really causes reactions like "so what?". I'm personally somewhat annoyed by news like these, because we should treat it like a normal thing if we want it to be one. But sadly there are a lot of people still that do not think as forward as people who accept homosexual people yet, so being annoyed by titles like these might be a bit selfish and idealistic.

Nonetheless, I can't wait for a time where 99% of the people react with 'who cares?' to such a headline.