The Jewish Publication Society commentaries on the Torah and other such commentaries speculate on problems like this.
The Jews do not emphasize original sin like Catholics do. There’s a notation in the CCC about that, probably around the discussion of original sin.
What the Jewish commentaries say, is that, according to some analysis of scripture, that they believe that the Torah was written in God’s mind thousands of years before world was created. And, the world was created with the Torah as the “script.”
The Jewish commentaries (starting back with the Talmud) are always motivated by a belief in harmonizing scripture with their faith. So, they simply accept and teach that G-d, of course, knew what he was doing and how things turned out.
But, the scripture, esp. the Torah, is God’s love letter to them. So, they are looking for the earthly paradise that they see promised there, the promised land itself, etc.
In that book Why the Jews Rejected Jesus the author notes significantly and critically of Christians, that we’ve spiritualized everything, starting with Jesus — our kingdom is not of this world,etc.
The Jewish commentaries point out regularly all the anthropomorphisms about God. I imagine that our Christian belief that sin offends God is an anthropomorphism, for all the same reasons that the Bible has anthropomorphisms – to teach us about God.
I was reading the ACCS which you know well about, and the thought occurred to me that “Father” and “Son” are anthropomorphisms that best describe to our ability to understand, the relationship of these two hypostases of God – two persons of God. certainly the Father is not a Father in the natural sense, but always in a spiritual sense. LIkewise, the Son.
Anyway, God cannot and does not change, so sin cannot really offend God in the way to make any change. (I am neither a philosopher or a theologian, by the way.) So, what happened from creation onward was willed by God or permitted by God, including our concupiscence.
Only those who have faith have been given that faith by God. That’s another mystery - in the sense that this principle has been revealed to us, although it is beyond our comprehension.
In the ACCS on the gospel of John, Augustine is quoted at least several times as saying there are things we don’t know and may never know.