Seven ships of the Royal Navy have been named HMS Melpomene after the Muse of Tragedy in ancient Greek mythology.