A major maritime search has ended in tragedy after the bodies of two men were pulled from the water on NSW’s Central Coast.