Yeah yeah! OK dad!!! I know, you did
Surprisingly though, the lance continued its use in many contexts even into the 20th c in WWI. German uhlans had incredibly long steel lances, and there were numerous contingents of Bengal and other lancers with Great Britain in a number of campaigns.
Most of what I have read on New Spain did note that the lance was favored over the use of guns as a primary weapon in the frontiers. As noted, the lack of powder and paucity of firearms themselves were key in that preference.
In the more metropolitan areas and cities this was not so much the case.
While one of the most intriguing conditions in New Spain was that remarkably obsolete arms and armor continued in use long after they were no longer in use in Europe. However, the use of the lance was not related to this proclivity of obsolete arms forms, such as the lance, but was actually more toward the notable use of the lance by American Indian warriors which revived the usefulness of them with the Spaniards.
Toward the unreliability of firearms, the advent of the use of the tomahawk by colonials was presented by the Indian tribes who learned that they had a window of attack using these as the colonists reloaded. Clearly this was not as opportune with soldiers using volley fire, but with loosely formed groups firing independently it was of course used as noted.