I think you are right, most Mexicans would welcome an American takeover.
In a recent poll, 58% of mexicans living in the Southwest believe that the land rightfully belongs to Mexico.