If God were to literally forget our sins, as in erasing them from His memory in the way that humans forget trivial details, this would introduce serious theological problems.
We don’t find a hyperspiritual, out-of-touch vision of faith in the Psalms; instead, what we are presented with in the Psalms has blood and sweat and tears.