My (now ex) husband felt very strongly about raising our children catholic.
I had been raised catholic, but had drifted away in the years before we married.
I agreed to raise the children 'catholic' - but made it clear that I was going to be involved with the 'catechism', and also was NOT going to be a 'go to church only on sunday' parishioner.
And I wasn't. Funny thing IS, that in spite of his Notre Dame education, he was remarkably UN involved in the church.
During (and post) divorce, I felt totally unsupported by our particular faith community. The kids were 16 ish to 9 when we divorced.
I left the 'church'.
The children are ALL moral and valuable members of society. They have ALL (over the course of the over 10 years post divorce) explored many 'religions', faiths, cultures and philosophies. And *I* have supported that quest/desire.
I personally do not think their respective 'moral compasses' are a result of their early learning from 'the church'. I think it has had more to do with a foundation laid of respect, tolerance, and 'doing the right thing' as though *I* were the one looking over their shoulder!!
Not sure this answers your question, but it has been my experience.
As a side note, when the divorce was finally final, the 'ex' expressed NO interest in keeping up with the kids in ANY way...to include their catechism.
Best!