A nine-year-old boy has drowned after being pulled unconscious from a popular Sydney swimming hole.