We listen to the Sons of Korah in the car and around he home. My 5 yr old sings all the way through scores of Psalms set to contemporary music that you will all enjoy! My teenagers love it too
Our regular hymnal is part of our day-to-day family life. We used to belt out "A Mighty Fortress" at the top of our lungs to assuage the fear that one of our sons had of the car wash. I have mixed feelings about some of what's designed for children. It seems like Judy Rogers had CDs that were straight-forward with the children's catechism and some simple verses, and those were fine, but is seems like a lot of what's designed for kid's music is overly sentimental and sometimes simplified to the point of error.
I do use the Metropolitan Tabernacle Hymn book for children. But mostly we just use regular hymn book’s and I set full Psalms to tunes so my children learn them off by heart super fast.
Jamie Soles music is great if you want some Biblical songs for the car etc. (Not hymns, but great Biblical music.) My son (3) was singing one of his songs at the top of his voice in the supermarket just last week. The lyrics go like this “This old man, he played three, he put me across his knee, with a nic nac whack a smack, give the kid the rod, this old man’s obeying God.” LOL I figured nobody but Christians would know what giving the ‘rod’ was anyway, so let him sing to his hearts content.