I have not read the thread, I was just advised to post a reference here. Maybe someone already did. I think the most enlightening book on this topic is “In the Beginning…”
A Catholic Understanding of the Story of Creation and the Fall by Cardinal Joseph Ratzinger
An excerpt:
Creation and Evolution
"All of this is well and good, one might say, but is it not ultimately disproved by our scientific knowledge of how the human being evolved from the animal kingdom? Now, more reflective spirits have long been aware that there is no either-or here. We cannot say: creation or evolution, inasmuch as these two things respond to two different realities. The story of the dust of the earth and the breath of God, which we just heard, does not in fact explain how human persons come to be but rather what they are. It explains their inmost origin and casts light on the project that they are. And, vice versa, the theory of evolution seeks to understand and describe biological developments. But in so doing it cannot explain where the “project” of human persons comes from, nor their inner origin, nor their particular nature. To that extent we are faced here with two complementary – rather than mutually exclusive – realities. "
In this book, iirc, our future Pope characterizes Genesis in it’s first 13 chapters as “mythological in nature.” Not false, not fantasy, but based in something actual, to explain certain things: what we are and what our relationship to God is.
It’s a really remarkable piece of writing, I encourage folks to find it. I bet Amazon has it used really cheap.