A cumulative $12 trillion will be spent on clean energy in North America by 2050, but neither the U.S. or Canada are on track to hit net zero by then, says consulting firm DNV.