A rusting rocket discovered in a man’s garage in Washington state is in fact an inert nuclear missile, police have said.