About the category moderator feature

Yes, that is exactly how the feature was designed.

You should not put a user as a category moderator of you don’t trust him/her, like all staff powers.