Of course people are afraid of losing their job to foreigners, but if you look at the big scheme of things: every worker is also a consumer. Meaning every immigrant and his family will also buy more American products, go to the hairdresser, pay taxes etc. and thus indirectly create work for other people.
I really hope Obama is free market enough to make the moves in that direction.