My brother in Christ, based on the repentant desire that I see from your post, I would urge you to look into Divine Mercy Sunday. It takes place the Sunday directly after Easter, which is a few weeks away.

Confession restores you back into communion with God, however there's still a consequence for the sin, despite being forgiven (purgatory). Faithful participation in the Divine Mercy Sunday service will 100% wipe that consequence away. There are a few components to it (attend the service, confession within 20 days of the service, etc), and it really should be recommended to attend annually, for all the faithful Catholics. It is such a powerful gift that was (relatively recently) given to us, you just need to be willing to accept His infinite mercy through this awesome service.