that Ted Haggard doesn't want forgiveness, he wants an important and lucrative job preaching and teaching to a large congregation of believers. I do believe that many of his former flock has probably forgiven him, or even forgotten him. Simply being forgiven doesn't entitle one to return to a leadership position.
He attempts to compare himself to a CEO, but the comparison is inapposite. CEOs make no claims of being moral leaders, rather they are in the business of making and handling money, and while it may be true that a CEO who is caught in a compromising position with a gay prostitute may not lose his job, it is likely that a CEO who is caught with his hand in the company till would be fired and prosecuted, and would further be unable to get another job in the financial industry regardless of the level of "forgiveness" he or she experienced. Mr. Haggard's conduct, vis-a-vis the church that he chose to enter and the flock he chose to lead, is more akin to a CEO stealing money than to a CEO having secret gay sex.
I disagree with that particular church's position on homosexuality. However, that is their position, and no one who disagrees with that position is likely to be a moral leader of that particular church.