No, the big dipper is not visible from Mexico City.
The Big Dipper is an asterism in the constellation Ursa Major, which is circumpolar for observers north of about 30 degrees north latitude. Mexico City is located at about 19.5 degrees north latitude, so it is too far south to see the Big Dipper.