Emergency services rushed to the Majorcan port of Palma but were unable to save Charlotte Conradie, 29, who had been found lifeless in her cabin on Sunday night