Nuclear tipped ICBMs put an end to that. It's even questionable how much should a president drink alcohol while in office. A drunk president ordering a preemptive nuclear strike likely would be ignored by the military but a drunk president when an attack is incoming would be a very bad situation.