I’ve been an ordained minister now for 17 years and a Christian for nearly 30. I’ve been in churches that were contemporary and sang only rocking praise choruses and I’ve been in traditional churches that only sang hymns, sometimes very poorly. One thing I can say with a great deal of certitude; you should sing Psalms and hymns.
The Psalms are God’s songbook and if you’ve read them in any depth, you soon realize they are as deep as they come and tailored to every season of life. You can’t trump the wisdom of God. Also, you won’t be one who stabs around wondering what to do when Islamic terrorists kill your brothers and sisters in the faith in the Middle East…you’ll sing imprecatory Psalms like 69.
And what of hymns? Good hymns tell full stories, have memorable tunes, and are often trinitarian. Sometimes they are warlike and others are deeply profound with words written by some of the greatest wordsmiths and saints like St. Patrick and GK Chesterton. The tunes are arranged by matchless composers like Bach and Vaughan Williams.
Someone might say, "the words are difficult and the tunes seemingly inaccessable." My answer is, and here's the takeaway, they grow you up. Learning how to sing skillfully and to be immersed in a context of deep and mature music will grow you up.
In conclusion, Psalms and Hymns will grow you, and in particular your children, up. After observing and experiencing the modern church broadly I can say that kids who are raised on a steady diet of Psalms and hymns (particularly if they're sung well and with gusto) are far more mature, reverant, and substantial young adults than those raised on contemporary praise music. How can they not be since they're being shaped by content and music that is deep?