I am not religious and to be honest if my kids grew up to believe in god I would be secretly disappointed. I would feel like I had failed to teach them how to think in a critical scientific fact based manner. I wouldn't tell them I was disappointed and I wouldn't try to change their mind. That being said if they said something I thought was total BS (there were no dinosaurs etc) I would tell them what I thought.
If my child grew up wanting to learn about many different religions I would be delighted.