It’s because the US dollar is currently worth 17.14 Mexican pesos, and currently worth (as an example) 7.87 Guatemalan dollars, meaning they are functionally making less money in Mexico.
Keep in mind a lot of these migrants are men who send money home to their families, so exchange rates matter hugely.