But... alcohol should be legal, no? Despite the harm it causes, prohibition simply does not work.

Cannabis can also cause harm (albeit less harm than alcohol) but should also still be legal. And other drugs like fentanyl (arguably) cause more harm than alcohol...but should also be legal.

Prohibition is literally never a realistic solution to any drug or drug problems. Not a single country has ever had success.