I don't think religion will go away for a long time. It's part of society. But hopefully we're coming to an age (and we're already seeing this in US Christianity) where's it's non-intrusive, and more spiritual and personal instead of intrusive.
"The consolations of philosophy and the beauties of science; these things are infinitely more awe-inspiring and regenerating and majestic than any invocation of the burning bush or doctrine." - Christopher Hitchens