Canada

You may call that a solution, but that sounds like continuing the problem (that is, substance abuse).

Substance-abuse pales in comparison to death. I don't care if people are addicted to substances as long as they continue to live they have an opportunity to quit.

But if the government is saying there’s not enough money to continue, what’s the next step?

The government isn't saying that. The government is saying there isn't money to expand the programs. This is primarily political because people on the right have attacked evidence-based addiction treatment.

what’s the next step?

More deaths. Either that, or expand safe supply which as previously noted has political opposition from the right. Conservatives are playing politics with peoples lives.

You know what they say: “Prevention is better than cure.”

If you want to prevent deaths due to toxic drugs, the obvious answer is to provide non-toxic drugs. You have no control over whether or not people use drugs. The only thing you can do with 100% certainty is provide clean safe drugs.

It may be true that some people will simply stop using drugs in their own time (not likely with opioids)

Show proof that opioids is less likely.

getting 1 out of 10 people to sober up is much better than enabling continued consumption through “safe alcohol consumption sites”, right?

Not if the other nine are dead, right?

With the limited funds available, what approach would be most effective to tackle this problem?

Safe supply and harm reduction. Clean, safe drugs including stimulant would cost very little. In addition the money saved from policing, courts, incarceration plus reduced burden on paramedics and others in healthcare means that even after the government provided safe supply they would still be saving money.

Ironically the right wing libertarian Cato institute believes the same thing. https://www.cato.org/commentary/economic-moral-case-legalizing-cocaine-heroin#

As I previously explained, this is political. The NDP is worried about right wing backlash in the approach to an election. Instead of doing the right thing, they have caved to political pressure.