While U.S. tariffs on Canada's auto sector are expected to raise prices on new and used vehicles, the increased costs aren't expected to happen overnight.