Luckily DS is still too young (20m) to understand, but:
I was born and raised in a country with a strong Catholic culture. Learned my prayers very early, went to church every Sunday, did my Holy Communion, confirmation etc.
During the early teenage years religion gave me some comfort, but later on I detached myself. Got a degree and PhD in hard sciences and became very much the "I want to see first" type. DH followed exactly the same path.
But we got married in church, because somehow we feel guilty of this and thought it was the right thing to do.
I really would like to provide DS in his childhood with the same comfort I had, give him a positive explanation of negative events, death etc, but how can I get him to follow this path if we don't lead by example?