A seven-year-old boy is in critical condition after being pulled from the water due to strong tides.