Ideally there would be a commitment to green hydrogen, i.e. hydrogen which is not produced by steam reformation of natural gas, but rather good old fashioned electrolysis. Green hydrogen can be made, compressed, and stored at the site of the filling station, the only inputs needed are water and electricity from renewable sources (solar, wind, hydro). This eliminates having to deliver heavy high pressure tanks from anywhere to anywhere, and the only tankage involved is at the filling station and in the hydrogen powered vehicles themselves.
I'm pretty sure that unless forced to do so by government however, CN and CP will do whatever is cheapest. In today's market that's buying hydrogen created from petrochemical sources, and schlepped across the country by fossil powered transportation. This new locomotive isn't even a baby step, it's the first attempt at a crawl.