I'm sure his attitude toward the gay agenda has softened considerably since he's gotten such fair treatment from them lately.
Jesus spent time with prostitutes but that doesn't mean he supported what they did.
I do not think that this man was "counseling" the gay prostitute but he probably still thought that his own actions were wrong.
You would think the worst thing in the world is hypocrisy or that a leader's failure negates the faith itself. We saw the same attacks on Catholicism around the minority of priests involved in molestation and cover up, for example. One should judge a faith on its own merits, not by the failures of the self-proclaimed faithful.
It seems his beliefs were sincere although it took him some time to own up to his activities. It's clear he lived as a heterosexual for almost 30 years and fathered five children. It seems he wasn't some man trolling public restrooms all that time, for example, and despite the firestorm of press there's been one "accuser" who failed portions of a lie detector exam.
He did the right thing, finally, by stepping aside.
I am, however, very concerned about the "methods" which may be employed in any rehabilitation he'll be undergoing. I see he'll be subjected to lie detectors, there's a battle of whether he was always wrestling homosexual feelings or had been 'recruited' or what. I believe one can manage behavior, control temptation, but am suspicious of claims so-called ex-gays are ever "cured" or "converted" into pure heterosexuals.