A woman has drowned in the waters of a pristine Australian tourism destination despite desperate attempts to save her.