Yeah I live in Alberta. There's a high single or low double digit percentage of the population that would entertain the idea of joining the US, but the idea is still pretty unpopular with the large majority. All of this is ignoring indigenous groups that signed treaties with the federal government that would put up serious roadblocks to any move to join the US (and they have already declared as such).