With the legalization of marijuana consumption has gone up. https://www.sciencedaily.com/releases/2022/07/220719162133.h...
So to say they failed is not fact, very few laws eliminate the act that is illegal. Murder happens despite being illegal, and will continue to.
I would agree the cost is too high, that the policy is wrong, but it is pretty clear the illegality reduces consumption.