General Petraeus succumbed to a common human failing. The handling of his affair by the Obama administration raises more important questions.