As an NS conductor, I can confirm, the alerter alarm is the loudest beeping sound known to man. As you said, it could wake the dead.
Another thing to note, at least on newer NS motors, the engineer has a countdown on his display as to when the alerter will begin to sound. If no action is taken...