No, purgatory itself is not joyful. The Bible clearly describes it as a “loss” as it deprives the faithful, albeit temporarily, from abiding with Christ. The joy is realized when the soul is released and enters heaven, not before.
Now wait a minute. What about those members of the church the Body of Christ that are in purgatory, according to your Church? Part of the Body is in heaven, part on earth, and part in purgatory?
I disagree. Those in purgation know they are saved and that their purging is for their good. I think they are joyful in their loss.