Most people are in favor, a minority aren't. Population inversion should scare people more than it does, but right now the current dominant fear for people is housing costs, which immigration rates are being (very incorrectly) blamed for.

If you ask the average person, they probably would reply "immigration is fine as long as we can provide for everyone". The average left-leaning person would be more likely to drop the conditional, and the average right leaning person would say "verb the noun" and ask why we're letting immigrants take out 300k loans from banks and then leave the country with the cash[1].

It's a mixed bag, as with anywhere.

[1] this is not happening in any meaningful capacity and most immigrants can't secure any credit at all without collateral, but this is nonetheless a very real conversation I've had with a post-secondary educated semi-friend who really should know better