I have found lots of sources that say otherwise. You only need validity to cover the time you are there. You don't need six months if you're just staying two weeks.
"The Mexican government only requires that
your passport must be valid during the entirety of your trip."
https://consulmex.sre.gob.mx/washington/index.php/servicios-para-extranjeros-visas?id=182
"When traveling to the USA, the general rule is to have a passport that is valid for at least six months after the planned time of return.
However, there are some countries, citizens of which can enjoy a bit more freedom regarding their passport expiry rules when traveling to the USA. For citizens of these countries, the passport validity must only cover the time of their intended stay in the States." [Mexico is one of them]
Passport Validity for Travel to USA: What You Need To Know
"The countries that have an agreement with the United States allowing entry with a passport until the date of expiration are as follows:"
[Mexico is one of about 60 listed.]
Travel