Backport CASSANDRA-16905 to older branches

Recently hit an un-recoverable situation in Cassandra 4.0.10 after dropping a 'map' column and adding it back as a 'blob', which caused corruption that neither offline nor online scrub could fix.
When dropping a 'blob' column and attempting to add it back as a 'map' type, the operation is blocked with:

InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot re-add previously dropped column 'col1' of type map<int, tinyint>, incompatible with previous type blob"

We need to do the same going from 'map' to 'blob' to avoid this potentially very bad scenario that can cause data loss.