who was made to go to church every Sunday.  As an adult, I completely rejected organized religion.  Sunday services aren't that fun for kids.  They aren't meant to be.  Its ok if that is an "adults only" activity for you.

This doesn't mean your son can't be exposed to your faith, religion and church.  There's probably activities that are geared towards the kids.  Encourage him to be involved in those.  I think in the long run, he might grow up with a happier view of religion.