The version I've heard is that beating Drake's drum will cause his fleet to rise from the bottom to defend England. We won't comment on how well a 16th-century sailing vessel would fare against even the lightest of 21st-century warships.
I like the legends, though.