A tourist has died after being pulled from the surf at Palm Beach on the Gold Coast, with emergency crews unable to revive him despite frantic attempts on the sand.