No Elton John song matches this description.
"Rocket Man" (1972) is about an astronaut's isolation—not a drowning child. The music video (2017, dir. Majid Majidi) features a boy watching a rocket launch, but no drowning.
Possible confusions:
If you recall a specific lyric or context, I can help identify.