The U.S. president wants support for his unorthodox agenda—yet he has weakened those in Canada who would have done so.