The auto tariffs are set to target a sector that employs more than a million U.S. workers and relies on a supply chain closely intertwined with Mexico and Canada.