Users table "Role" column values disappear

That’s correct and expected behaviour.

Roles can only be assigned when the user record is created, and only if the creating user has the same role.

Other than that, roles can be assigned via the Data Editor, or via the Glide API.