Tom Chapin, Harry’s more talented brother, has a series of great children’s songs that are just as much fun for adults. His stuff is clever, humorous, sophisiticated and often quite sweet without ever becoming cloying. “Family Tree” is a good place to start.
St. Judy’s Comet by Paul Simon is a lovely lullaby written for his son. In addition, Loves Me Like A Rock and Mother and Child Reunion are also evocative of the bond between a mother and child.
Billy Joel also has a lullaby (presumably to his daughter) called Lullabye (Goodnight, My Angel).
Beautiful Boy (Darling Boy) by John Lennon was written to and about his son, Sean, who was then 4 years old. (It ends with him whispering “Good night, Sean… I’ll see you in the morning”, and he recorded it just a few months before his murder :()
Will Smith recorded a song called Just The Two Of Us about and to his son that heavily sampled the song of the same name by Grover Washington and Bill Withers.
Neil Young has a song Sugar Mountain which is about growing up and leaving youth behind. (Oh, to live on Sugar Mountain, / With the barkers and the colored balloons… / You can’t be twenty on Sugar Mountain / Though you’re thinking that you’re leaving there too soon…)
Eminem had a recent hit called Mockingbird written to his daughter, Hailie (though it is rather dark).
On an even more depressing note, Eric Clapton’s song Tears In Heaven is a song addressed to (in the second person) his four-year-old son who fell to his death out of a window of a high-rise apartment building in a freak accident.
On the other hand, Sweet Child O’ Mine by Guns ‘n’ Roses is not a song to a child, but could be
I would recommend just about anything by Trout Fishing In America. It’s kids’ music that doesn’t irritate most adults. Ditto for Peter, Paul & Mary. Someone mentioned both Paul Simon’s song St. Judy’s Comet and Kenny Loggins’s Pooh Corner – Loggins has an album (Return to Pooh Corner) that includes both these songs, and a bunch of other kid-friendly songs like The Rainbow Connection, All The Pretty Little Ponies and Too-Ra-Loo-Ra.
Checking on Amazon, I see there’s also “More Songs From Pooh Corner” and there’s a bunch of other recommendations in their “people who bought this also bought” thingie.
You might also look for Songs For Our Children - pop artists recorded children’s songs to benefit the Pediatric AIDS Foundation.
From the time they were babies, I’d hold them while dancing to Brown Girl in the Ring, then stop moving suddenly when the music stopped in the middle, then start again. It got gleeful giggles from them everytime.