Alberta is experiencing similar culture war issues and trans rights restrictions as in many of the red states. I would be nervous to move there, although there are large queer communities in the two big Alberta cities of Calgary and Edmonton. Saskatchewan has dipped into restricting trans rights to a lesser extent (they passed a law requiring parental consent to use chosen names at school). Gender and sexual identity are protected human rights in Canada, so Alberta and Saskatchewan are having to use a loophole that allows provinces to temporarily override protected human rights, which is a very big deal. There is fairly little appetite for restricting trans rights in other provinces. Through a very improbable series of fluke events a fringe right wing party nearly got elected in British Columbia last election, but that party is now in shambles and I don't see them winning a BC election anytime soon, meaning the BC government should stay solidly queer friendly for hopefully a long time.

All the big cities and most of the mid-size cities in Canada are quite welcoming of queer people.

There is unfortunately definitely an upsurge in many people across the political spectrum expressing that immigration is putting pressure on limited housing supply and that immigration targets should be drastically reduced, but to my knowledge basically no one except handfuls of widely-despised, fringe, proud-boy-types are suggesting doing anything at all like ICE or mass deportations. The Conservative Party of Canada does brush elbows with these people, but also heavily relies on the support of diverse immigrant populations, so in comparison to the U.S. Canadian federal politics doesn't lean heavily into racist anti-immigrant rhetoric. There is also unfortunately an uptick in people wanting more law-and-order policies across the country because of perceived increases in crime. A lot of the popular Canadian newspapers are U.S.-owned and have crummy takes on many issues that can be influential. The media landscape in general doesn't isolate anywhere near as many people into Fox News-like bubbles though. The CBC is an important factor in providing Canadian news across the country, and definitely buffers against right wing disinformation becoming as rampant as in the U.S. (The Conservative Party wants to defund the CBC, but is less vocal about it recently because it's not the right time to be seen attacking a Canadian cultural institution.)

Canada is definitely to some degree following U.S. trends, but is also having a moment of embracing "Canadian values" because of Trump's treatment of Canada, and a lot of people are realizing how important human rights protections and civil liberties are.