John Tower's nomination as Secretary of Defense was derailed after his long history of drinking and womanizing becamse public