It really scares me.

[Mudhammam]

Of course they were wrong/ignorant about the scientific details of the actual processes involved but the general idea is that you have a period of formation in stages which originates from a deliberate point of creation by a single supreme intelligence.

Of course it is the general idea. When you look at the moon, you can probably see a man's face. When you look at various cloud formations, you might see objects or faces that are familiar to you. That's how the brain works-- it is called the facial recognition module. When people tried to conceive origin stories, they also featured anthropomorphic deities, with human characteristics and emotions.

The evolution of the various different forms of life on Earth can therefore just be a part of the overall process of formation so there isn't really an issue with it.

So much for that whole "the wages of sin is death" bit though, right? You know, microbes died too. Was that a penalty for their sins?

Every culture had their own creation myths of course, the one that eventually ended up in the Torah/Bible developed in the near East. But it can still be a revelation from God which contained certain truths separate to science but providing a context to what we understand through science.

Except that it offers us no context beyond its blend of prior Mesopotamian myths that dominated the culture. In what context is there an ocean of water above the "firmament" (you know, that thing that is supposed to contain the Sun, the moon, the stars, and light)? If anything, the biblical account of creation only impeded scientific knowledge, since as St. Augustine suggested (and later echoed by Martin Luther), "Whatever the nature of the waters [above the firmament], we must believe in them, for the authority of Scripture is greater than the capacity of man's mind."

I suppose you could have an infinite number of multiple universes each with their own unique laws of physics and we happen to be in the one that's right for life if that's you want to believe,

No, I don't want to believe anything. I simply want a justified confidence in any given theory that best describes and accounts for all the facts we have apprehended.

but we're not in "the truth is staring you in the face!" territory. Even the Pope accepts in evolution as factual truth of reality.

Who cares what the Pope says. He also endorses Original Sin, which is part of a tale rendered completely nonsensical in light of our biological heritage.