What happens to the record when a Creator leaves my agency?

The Creator can update “Managed by” after they leave. The person who controls the social account controls that field. An agency does not get separate editing rights just by being listed.