I think it is reasonable to both believe and hope that religion will one day cease. However, destroying religion should not be the ultimate goal.
I think of this idea much like I think of the phrase “money is the root of all evil”. Money is not the root of all evil, and it is ridiculous to think so. Much evil has been centered around money, but there was certainly evil before currency, and even before language. Money is often correlated to evil; but our goal should not be to get rid of money, it should be to get rid of evil.
Similarly, we dislike religion because it promotes bad behavior - the advocation of intelligent design as a scientific theory, when it is clearly neither credible nor scientific, the proposal of an anti-gay-marriage law in the US, and whole hosts of negative behavior in our world’s history. And yet religion itself is not at the very root of these actions. There have been violent and horrible atheists (though disproportionately fewer, to be fair).
The qualities we view as “good” are those of being independently moral, and of being critical thinkers.
The person who is independently moral has an internal notion of what “right” and “wrong” are, and acts this way without need for threats, praise or condemnation, and without need for the “right” action to be legal or in accordance with the rules of the bureaucracy. The morality spawned by religion is anything but; strongly religious individuals tend towards absolutes that many others would disagree with - “lying is always wrong”, “killing is always wrong”. (What about lying to the Gestappo to protect the Jews in my basement? What about killing the Gestappo if he tries to force his way inside in order to kill the Jews?) These religious individuals promote morality from a fear perspective - do what God says, so that he won’t send you to hell. Certainly some religious individuals have a stronger degree of independent morality within their religion, but this is more the exception than the rule.
The critical thinker, too, has a host of advantages over the imprecise thinker who is more able to make decisions from a purely emotional standpoint. Indeed, the ability to think critically and rationally is one that seems exceedingly rare, and just as valuable to the individual’s ability to reliably and positively affect those around him. When confronted with a moral decision, he does not need to rely on fall-back moral catch-alls (“never lie”), but is more able to assess the complexities of the situation in a way that better allows him to determine the best course of action. This individual is capable of discerning for himself whether or not Bush acted appropriately in, say, the NSA wiretapping scandal - and he discerns this independently of political propaganda from both sides. He is able to separate out his personal moral preferences from the course of action that is best for another individual, another country, or another culture - and would, for example, conclude that only funding pro-abstinence educators in Africa is far more detrimental than funding those who teach about safe sex and how to prevent pregnancy and HIV.
The goal of eliminating religion is a reasonable goal - but a far more worthwhile goal is to eliminate the human failures that lead to religion. Promote independent morality, critical and rational thinking, and the surety of self that allows an individual to not fear death, but rather look forward to a life well lived.