Aside from the theological considerations, keep in mind the massive cultural differences. The Scriptures span about 1400 years across different times and cultures. There’s a vast gully of difference between the early Jewish authors, hundreds of whom wrote the Old Testament, and had their own traditions and myths, (myths meaning not lies but richly spun narratives containing truth) . . . . and Greek authors - most likely schooled in Greek mythology and the classics - of the New Testament. Inevitably, these difference will color their concepts of God. It’s like listening to two vastly different genres of music yet finding value in each one. In fact, it’s quite mind-blowing to consider the connection between the prophesies of Isaiah - again, in a completely different time and culture - and what we read in the Gospels.
This question used to confuse me until I started some coursework in theology and church history. I’d encourage every Catholic to find a way to do the same - ate least through parish-sponsored adult ed programs.