Why Would God’s Spirit Cause People to Loathe Themselves and Be Ashamed?

Questions about why Ezekiel 36:31–32 would say, contrary to Ezekiel 39:25–26, that putting God’s Spirit into people will cause them to loathe themselves and be ashamed and whether or not it’s biblical to say that the closer you are to God, the more sinful you feel.

• Why would Ezekiel 36:31–32 say that after God puts his Spirit in his people, they will loathe themselves and be ashamed for their sins when his Spirit is supposed to give us hope and joy in Christ as children of God, and doesn’t this contradict 39:25–26?
• Is it biblical to say that the closer you are to God, the more sinful you feel?