Unique units might become unhappy with no way to fix it
They don't eat, they don't sleep, they only require gold. This one at the screenshot probably missed the payday or something, I can't think of any other reason for him to be unhappy. The spell which gives gold to a creature is not effective, his mood is still unhappy. So that's it, there is nothing players can do to make them content again.