Yes, the law should be changed, but not because drugs aren't bad. But because the high costs of enforcement (direct and indirect) have been worse than the lower costs of people being free to get high.

By your logic, we should continue to ignore all those costs because drugs are still a negative to society and the moral law must be enforced no matter the enforcement cost.