The whole idea is nonsensical. Canadians don't want to be part of the US, and they couldn't be just one state--all ten provinces would become states. That would mean a permanent Democrat majority in Congress.
The only rationale for Trump's remarks is to give him a better bargaining position in talks with Canada.