A lot of Southerners were opposed to nationwide Prohibition for state's rights reasons.

However, many Southerners were in favor of banning alcohol, as long as it wasn't the federal government that did so. The entire state of Mississippi banned alcohol until 1966.

Today, pretty much all the dry counties are in the South. Dry counties are especially common in Tennessee and Kentucky, which ironically are the 2 main whiskey producing states. Jack Daniel's brewery is in a dry county IIRC.