You’d think there would be a plausible hormesis explanation for the benefits of moderate alcohol intake.

Lots of systems in the body work this way. Eg we grow our muscles by literally damaging them and having them grow back stronger.