And they will be stopped by someone sane in the chain to actually fire these missiles. (Like it already happened several times.)

The danger is upfront : if there is a group of people insane enough to set up a system where there is no such chain. (As lampooned in Kubrick's Dr Strangelove (1964), in particular on the Soviet side.)