Transportation of nuclear fuel waste will come with its own set of hazards and risks. The practice is relatively unknown in Canada, and the few incidents of highly radio-active nuclear fuel waste being transported in Canada are not comparable to the frequency and volume of transportation that would be required to move all of Canada's nuclear fuel waste to a single location. There are risks of accident, but there are also concerns with the transport of the fuel under "normal" conditions.
Nevada has been doing cutting edge work on the risks of road (truck), rail (train), and waterway (barge) shipments of high-level radioactive waste, for decades, as part of its successful opposition to the Yucca Mountain dump.
There have been some 2,500 to 3,000 shipments of solid high-level radioactive waste in US history. But most were many decades ago. In recent years, it has slowed to a very small trickle. Many years, there are ZERO shipments of solid high-level radioactive waste.
Sub-links from the site above, specific to high-level radioactive waste transport risk include: