I would say that the two can coexist. I know that it was meant to be historical when written (not by Moses). But who would expect the early Hebrews to get anything scientifically correct. Christians can and do largely ignore the Old Testament. The morals of the OT are atrocious and most Christians can see that. The defense, ignore 90% of the OT. I can even quote one of the NT verses that gives them an out:
All Scripture is breathed out by God and profitable for teaching, for reproof, for correction, and for training in righteousness, that the man of God may be complete, equipped for every good work.
— 2 Timothy 3:16-17 (ESV)
If you read that nothing in that verse says that the Bible is inerrant. It does not even imply it. Any writing that is clearly fictional or immoral if read literally can be reinterpreted to be a morality tale or allegory as an excuse by apologists.
And since all Christians reinterpret the Bible or pick and choose which parts that they want to believe I do not see why that would not work.
The way I see for evolution and creation to coexist, is to look at Adam as connected to an upgrade in the operating system of the human brain, instead of to human DNA. Adam had human DNA, a did the caveman. However, the caveman did not have the new operating system that Adam had acquired. Adam's upgrade created a new type of human based on his brains upgraded operating system, still with human DNA.
The analogy is like saying Windows 98 all the way to Windows 11 are all Windows operating systems. However, Window 98 is the like the caveman of Windows while Windows 11 is like Adam. Adam had more that just natural selection behind him. He was connected to human selection and the rise of civilization about 6000 years ago. The extra capability allowed for new modern features.
Today, we do not have to wait for natural selection and evolution. We can use will and choices in science to make genetically modified cows or corn, instead of wait for natural selection. The higher brain symbolized by Adam was able to leave natural selection and evolution; symbolized by the tree of life being taking away from Adam and Eve. Taking drugs or vaccines to stay healthy, do not come from nature or natural selection. This is man made selection. This is not from the natural brain, needed for natural selection, or we would not take anything unnatural.
As a better real life analogy, I had used Windows based computers, since Windows 95. By the time of Windows Vista, my old computer could no longer be updated, due to the design of the mother board. So I decided to try Apple and bought an iMac.
I used to run both Windows and Apple operating systems on my iMac. Each had a separate partition and the Apple operating system allowed a way for me to read and write between the two operating systems, while keeping each secure. This allowed me to keep using all my old collection of Windows based Software like my Photoshop, on my Mac. I could work in Windows and transfer the results to my Mac. This is similar to the two trees; tree of life and tree of knowledge before the taboo and fall, when both trees were accessible to Adam. Once the taboo appeared, the tree of life partition was cut off.
When the tree of life was removed, the Windows partition was cut off, but not erased. Apple Support was no longer as available. This required I only use the Apple, which no longer allowed me to use my old Windows based software. The natural programs were gone, and Adam and Eve, had to be taught to do the same things but in a new computer language. I had to adapt myself to Apple and buy newer versions of the same software, that could run directly on my Mac.
This is the story of Adam and Eve in a nutshell. This new type of human, had will and choice, but had lost their roots and ease within instinct and natural selection; paradise. DNA was no longer the main variable anymore; legacy thinking, since now science and religion and will and chose; could alter the DNA. Adam was the first modern full iMac human so to speak who came from two partitions.
The Bible story of Creation essentially places the brain ahead of the DNA, via the higher priority of the new operating system. Evolution and the the Life sciences are too heavily invested in casino science which allow obsolete thinking to to linger. They do not have a rational way to modernize and place the brain ahead of the DNA, even if the brain is based on DNA, but also contains catalogs of social memory not on the human DNA; science and culture. Adding water to the organic centric casino science, makes the brain connection much easier to see.
Neurons pump and exchange cations causing the outside of the brain to become positively charged and in contact with water; cerebral spinal fluid. The blood supply is slightly negative. With nerve tissue and blood vessels near almost all cells, we have a water based gradient used for cellular differentiation control, centered on the brain. The brain has a blood-brain barrier, that separate the brain and blood, so the gradient can be maintained while still feeding the neuron from the blood. The DNA is like the hard drive. The brain is more like the operating system and secondary hard drive, since it also contains external data from the environment, such as data from all animals and all plants which do not have human DNA. The brain is beyond its own roots; consciousness.
Cancer could be solved by thinking in terms of the brain and water first. If we were to cut off a nerve ending near any cell, it would lose that positive charge that inhibits replication allowing the cell to multiple too fast. On day we may be able to bing the nervous system and spot single cells that are vulnerable to cancer, all at the same time. Cancer is not connected to the nervous system, so the brain loses control. We may be able grow nerves into cancer and reverse this. The brain has a backup copy of the ideal body and can work toward that. The secondary hard drive will add science data to help with the visualization.