For anyone looking into this in the future:

As pointed out in the comments, it is currently not possible to retrieve the Profile Effect of a user using the Discord API.

I’ve submitted a feature suggestion to address this limitation. If there are any updates or changes to this functionality, I’ll make sure to update this answer.