Given the stance taken in the CCC on creation evolution and the age of the earth. How can I go against what I think is harmful anti-God philosophy and become a Catholic?
Issues like creationism come from an almost total lack of understanding that 5,000 years ago, give or take a thousand, People wandering around in the Middle East had absolutely no conception of science as we understand it today. That is coupled with a mindset that says that the Bible has to be understood literally, word for word. The Bible doesn’t say that, and personally I have no idea where the various Protestant churches developed liberalism.
The Catholic Church approaches Scripture differently; it is contextualist in its approach. It asks "What is God trying to tell us about Faith (not about science). As a result, we don’t go down the path of literalist preachers. I suspect that if one dug into what, say, the Methodists, and the Presbyterians and the Anglican/Episcopalians believe in terms of Scripture, that one might find some literalists; but not to the extent of the other 30,000 +/- churches do.
Faith tells Catholics that God created the world. It is not an exact sequential laying out of how we got from a Big Bang to today; it is poetic; but it conveys the truth that God created all that is, without trying to cram down, ignore or debate factual evidence provided by science; it allows scientists to be scientists (and as an aside, it has been noted that many many scientists are believers).
Your misunderstanding , and calling it an anti-God philosophy completely misunderstands that it is not anti-God in the least, and has next to nothing to do with philosophy; it has to do with theology.
It is not c;ear or harmful to understand evolution if one understands that is God driven. If one denies that God could cause evolutionary changes, one limits what God can do. That, in turn, wouold seem to indicate that miracles cannot occur, because they ar outside of “normal”, whatever that would mean to a literalist.
People who reject God do not do so because the literalist interpreters of the Bible deny science. They do so because of a multitude of reasons, one of the primary ones being they want to determine for themselves what is right or wrong, and deny natural law and morality - one that even non-Christians can understand and accept. And given that many literalist pastors are anything but ambiguous about moral law, it is an easy lie to say :I am leaving because of science" when what they may be living is an other than moral life.