Nope. Mishandling classified material is absolutely disqualifying for that job. Even Mitt Romney would be better than Petraeus, not that Romney is a good choice either.
His security clearance was revoked. The mishandling of classified material, I think, should prevent him from getting a new security clearance.
Don