Sin is an offense against God (Catholic Catechism paragraph 1850). In no way could someone reasonably conceive of Jesus as an offense against God. God the Father was pleased with Jesus (Mt 3:17; 17:5)
It's axiomatic that Scripture is the word of God if it is translated and interpreted properly. A translation of 2Cor 5:21 by David H. Stern, a Messianic Jew, has it that “God made this sinless man be a sin offering on our behalf...”.
The first letter of John (1Jn 2:2) refers to Jesus as the atoning sacrifice that takes our sins away, supporting the idea of a sin offering. The New Jerome Biblical Commentary (1990) on 1Jn says "The theology of Christ's death as perfect sin offering by one who is not a sinner...is developed in Heb 9-10."(p990)(Especially Heb 9:26.)
Psalm 22 was prayed for a thousand years before Jesus prayed “My God, my God, why have You abandoned me?” There was no abandonment of the people who prayed in Israel (Deut 4:31; 1Sam 12;22; 1Kings 6:13;Ps 27:9; Ps 37:28; Isa 41:17). (On the other hand, if you forsake Him, He will forsake you (2Chron 15:2)). But the entirety of Psalm 22 attests to Jesus’s faith in God and to all that God has done for His people. Jesus has not abandoned God, and God has not abandoned His son. Jesus suffered and expressed his anguish in a way that could be understood by those who also suffer - yet even as He dies, He leads His people to God.
Possibly the Hebrew/Aramaic concept of "grave" (Sheol) became Greek “Hades” and then eventually “Hell” (the place of the damned). The very old (and the new!) translation of the Apostles’ Creed says Jesus descended into Hell. This would be consistent with Jesus being abandoned and damned as if sinful. However, a practical understanding would be that Jesus was buried. It might not carry deep spiritual overtones, but it proclaims that Jesus was definitely dead. If Jesus was sent to the place of the damned, His release must have been prearranged.
The Jewish custom on the Day of Atonement (Lev 16:6-10) prescribed that one goat would be sacrificed and another released. On the day Christ was crucified, a man named Barabbas was released (Lk 22:19). “Barabbas” means “son of the father”. So on this day of atonement, the Son of the Father was killed, while another “son of the father”, Barabbas, was released into the wilderness. Not two goats here, but two sons of the father. The sinful one was released (representing us?), while the sinless one, a sin offering, was sacrificed.
My conclusion is that Jesus was a sin offering, not sin, loved, not abandoned by God.