Nope, no exploding heads. Characters who are gay in canon get to stay that way.

Not that I particularly care about Dumbledore's sexuality. For the most part, he as a character is completely irrelevant to my enjoyment of the fandom. Now if Harry were gay in canon, that'd be another story. Not to mention an improvement.