Vulcan,
No leader can be 100% effective on every freaking area of their position. If you want to hold him in contempt for less than perfect effectiveness in everything, that's your problem, not his.
FWIW I hold the American Clergy of the Catholic Church at fault for that particular fiasco far more than a man over 2,000 miles away.
The main way to aleviate that problem is for the clergy involved to realize vows are not "negotiable" nor are they "conditional". Allowing Priests to marry would go a long way to helping as well but it goes against a very fundamentalist belief of the Church.