You’d think, but people certainly still choose MySQL these days, and without a really serious reason to other than familiarity.

By all means, use what you’re comfortable with but not having stuff like transactional DDL feels backwards at this point.