Mr. Petraeus’s admission and resignation represent a remarkable fall from grace for one of the most prominent figures in America’s modern military and intelligence community, a commander who helped lead the nation’s wartime activities in the decade after the Sept. 11 attacks and was credited with turning around the failing war effort in Iraq.