One man has died, another has incredibly survived, and a boy is missing and feared dead after a boat capsized in rough waves off Sydney's Northern Beaches.