A major search operation for a man last heard yelling for help off the South East Queensland coast has come to a tragic end.