David Greenholtz was reportedly walking along the beach in Los Cabos with his son when they were swept out to sea by a large wave