Herschel Walker veered off in a campaign speech to rant about werewolves killing vampires