A Navy admiral picked to become his service's top officer will instead retire, an extraordinary downfall prompted by what's being called poor judgment regarding a professional relationship