A British woman who was dropped into the sea off Norway while being transferred from a cruise ship to another vessel has died.