The search for a missing Royal Navy crew member off Ireland’s coast has ended without success, highlighting the risks faced by naval personnel.