So what does this mean for Canada?

A lot. It means nothing's getting financed until they sort this out:
It still remains unclear what the full ramifications of that decision will be, especially for private property owners, some of whom have already reported difficulties obtaining financing in the fallout of Justice Young’s decision.

Get woke, go broke.

Are you sure about all that?

It seems like you'd need to see the terms of the agreement. It might be something that gives the tribes some form of actual ownership interest title in the lands.....but that seems like an utterly implausible outcome.

A far more plausible outcome is that the feds and the tribes have clarified what "aboriginal title" actually means in a way that doesn't confer an ownership interest that would affect financing or formal transfers of property. IOW, that this is the tribes settling in a way that gives them something but doesn't cloud title.

The latter point seems far more likely than the idea that the federal government would voluntarily do something that gave the tribes everything they wanted in the original lawsuit, particularly since the federal government fought that lawsuit below and appealed it when they lost.