The word Purgatory means a place where one is purged. This is where one is purified before being allowed into the presence of God. Wisdom chapter 3 verses 1-6 might be applied to Purgatory by some. They are hopeful verses, not ones of condemnation.
The Church does not pronounce on who is in Hell. But remember that Hell is for those who have completely and unrepentantly turned away from God. Should one die while in a state of mortal sin and actually be repentant, then we must all trust in the mercy of God. God does not abandon those who really seek to do his Will, no matter how hard or far they fall. And we all fall.
I think it would be better for the sincere Christian to look forward to Purgatory than fear it, because, as I understand it, if you make it to Purgatory you are on your way to Heaven. And that’s good news.