One very valuable insight that I just had is that hotlinked_media_status is simply the first thing happening in the restore file. If you remove it manually in the existing database the restore will fail on the next statement (CREATE TABLE public.admin_notices).
So this is not about that specific type definition. It’s just a symptom of a bigger problem, I suspect that BackupRestore.move_tables_between_schemas(MAIN_SCHEMA, BACKUP_SCHEMA) fails to do what it’s gotta do.