I'm not is a position to run database queries to clean this up.
What would happen if I copied the 'course creator' role, then deleted the original role,
and then changed the copy's shortname to the original's shortname?
Would Moodle treat the replacement role as the original, or would it cause problems?
Maybe we should never delete the default roles?