Hey Treks,
Thank you for the question!
"...God stands far above the anger,
rage and indignation
ascribed to Him by primitive imagination..."
- Angelus Silesius (1624 - 1677), German Catholic mystic
Our idea of God can never truly represent Him as He is because He is infinite while our minds are finite. Throughout the writings of the Church Fathers the inadequacy of human thought to comprehend the Divine Essence is continually reiterated.
This informs our understanding of the "Old Testament" depiction of God.
To take these descriptions "literally" is what we refer to as the error of 'anthropomorphism':
The limitations of our conceptual capacity oblige us to represent God to ourselves in ideas that have been originally drawn from our knowledge of self and the objective world. The Scriptures themselves amply warn us against the mistake of interpreting their figurative language in too literal a sense. They teach that God is spiritual, omniscient, invisible, omnipresent, ineffable. Insistence upon the literal interpretation of the metaphorical led to the error of the Anthropomorphites.
The Catholic Church believes that God revealed Himself progressively in the Tanakh to his Chosen People, a progression that reached its revelatory culmination in the New Covenant. Thus in the Catechism the Catholic Church explains:
204 God revealed himself progressively and under different names to his people
Since then, although public revelation was completed with the death of the last Apostle, we have been progressing continuously in our understanding of divinely revealed truth - a process known as the "development of doctrine".
Here is what Vatican II said:
"...The plan of salvation foretold by the sacred authors, recounted and explained by them, is found as the true word of God in the books of the Old Testament: these books, therefore, written under divine inspiration, remain permanently valuable...Now the books of the Old Testament, in accordance with the state of mankind before the time of salvation established by Christ, reveal to all men the knowledge of God and of man and the ways in which God, just and merciful, deals with men. These books, though they also contain some things which are incomplete and temporary, nevertheless show us true divine pedagogy. These books [of the Old Testament] nevertheless show us authentic divine teaching. Christians should accept with veneration these writingswhich give expression to a lively sense of God, which are a storehouse of sublime teaching on God and of sound wisdom on human life, as well as a wonderful treasury of prayers; in them, too, the mystery of our salvation is present in a hidden way..."
- Dei Verbum, Vatican II
Here is how the Early Father Origen approached this issue:
Origen (c. 185 - c. 254)
And now, if, on account of those expressions which occur in the Old Testament, as when God is said to be angry or to repent, or when any other human affection or passion is described, (our opponents) think that they are furnished with grounds for refuting us, who maintain that God is altogether impassible, and is to be regarded as wholly free from all affections of that kind, we have to show them that similar statements are found even in the parables of the Gospel; as when it is said, that he who planted a vineyard, and let it out to husbandmen, who slew the servants that were sent to them, and at last put to death even the son, is said in anger to have taken away the vineyard from them, and to have delivered over the wicked husbandmen to destruction, and to have handed over the vineyard to others, who would yield him the fruit in its season. And so also with regard to those citizens who, when the head of the household had set out to receive for himself a kingdom, sent messengers after him, saying, ‘We will not have this man to reign over us;’ for the head of the household having obtained the kingdom, returned, and in anger commanded them to be put to death before him, and burned their city with fire. But when we read either in the Old Testament or in the New of the anger of God, we do not take such expressions literally, but seek in them a spiritual meaning, that we may think of God as He deserves to be thought of. And on these points, when expounding the verse in the second Psalm, ‘Then shall He speak to them in His anger, and trouble them in His fury,’ we showed, to the best of our poor ability, how such an expression ought to be understood.
(De Principiis, 2, 4, 4; ANF, vol. 4)
For those who do not understand these and similar expressions in the sacred Scriptures, imagine that we attribute to the God who is over all things a form such as that of man; and according to their conceptions, it follows that we consider the body of God to be furnished with wings, since the Scriptures, literally understood, attribute such appendages to God...
We speak, indeed, of the ‘wrath’ of God. We do not, however, assert that it indicates any ‘passion’ on His part, but that it is something which is assumed in order to discipline by stern means those sinners who have committed many and grievous sins.... It is manifest, further, that the language used regarding the wrath of God is to be understood figuratively from what is related of His ‘sleep,’ from which, as if awaking Him, the prophet says: ‘Awake, why do You sleep, Lord?’ and again: ‘Then the Lord awoke as one out of sleep, and like a mighty man that shouts by reason of wine.’ If, then, ‘sleep’ must mean something else, and not what the first acceptation of the word conveys, why should not ‘wrath’ also be understood in a similar way?...
(Contra Celsus, 4, 37 and 4, 72; in ANF, vol. 4)