This man pissed off the powers that be. You don't resign in disgrace over an affair. If that were true then 2/3's of the senate would have been tossed out on their asses over the years.
Petraeus crossed some powerful people and now he's paid the price.
boisterous hubris, arrogance, self deception, conspiracy, mud slinging mixed with a heavy dose of self righteousness.