The End of God?

Is it realistic to expect that science will eventually put an end to god? The BBC, in this thoughtful presentation, seems to initially support the idea that this will be so. However, comments made at the end left me less sure.