I think the US would attempt to destroy the Mexican government. If it came to it, yes they would invade, although first they would simply try to install a friendlier government through a coup of some sort (it has been US policy to oppose any such actions since Monroe doctrine). As for the feelings of the US public, they can be swayed to war, as history shows.