Some other singable (and drink-amenable songs)of the ilk are
-- Ben Backstay
-- Don't Forget Your Old Shipmate (also sung in Master and Commander)
-- Roast Beef of Old England

Nigel refers to Thomas Hardy's 'The Dynasts'. On Brass Monkey's CD 'The Complete Brass Monkey' they perform "The Night Of Trafalgar", saying Hardy wrote the lyrics for The Dynasts. Brass Monkey's own Howard Even composed the tune they use. Here's Martin Carthy's notes:

"Thomas Hardy's loathing of war and all that it does to people is nicely placed in this song from his mighty and unperformed work 'The Dynasts', where fishermaen who have a very hard life indeed consider themselves blessed in comparison to the men of the battlefleet at Trafalgar who, having endured the hardships of battle with enormous numbers of dead and wounded, had then to cope with a huge storm which, by all accounts, took more lives than the battle itself."

There are a bunch of obscure Nelson-era Navy songs on my CD "Roast Beef of Old England".

Jerry