Sorry to trouble you with this - I'm sure this song is so famous, someone will answer this within seconds.

What is the song about the king wanting someone to captain a ship in a storm and (a Lord?) is suggested (by people who want shut of him) although he's useless and he drowns.

Thanks.