Sure it is: street prices are stable or falling, ever more dangerous drugs are reaching the market (e.g., meth), while billions in WOD-inflated profits are funneled into criminal hands. If that ain't failure then the War On Poverty was a ringing triumph.
And fewer people use illegal drugs than alcohol or tobacco. It's a success by that measure for sure.