I was unaware of Rails support for custom enum types in PostgreSQL.

It looks like Rails 7.1 will proper support for dropping them in migrations