Borders have been closed since late spring. The latest extension keeps them closed until October 21st, but could again be extended.
However, essential travel IS permitted, and that includes TN visa holders as a part of “essential workers”.
US-Canada and US-Mexico Land Borders Still Closed
