While it's quaint to imagine there's a lot of power in these old prophecies you have to understand the larger socioeconomic contexts that these beliefs exist in.

Unlike the nomadic Navajo, the Hopi were an agrarian society that settled into permanent villages. For most of human history agrarian societies exist in a world of fairly predictable cycles, but interconnected cycles:

The cycle of day and night which establishes the working day, the cycle of seasons which alters the cycle of day/night (longer days in summer shorter in winter etc), multi-year weather cycles which can impact the seasonal expectations: periods extreme drought, extreme rain, extreme cold, that are temporary but occur several times in a life time.

The occasional multi-generational disruptions the lead to an understanding that sometimes lakes do dry up, and sometimes they appear.

Nearly all religions and beliefs of settled agrarian societies speak of these cycles, we see this in Hinduism as well, Taoism etc.

The thing is all of these societies lived during relatively stable periods of climate so there was ultimately a multiple generation belief that even though things do sometimes get really, really bad, it's always okay in the long run. The cycles dominate everything and everything you have will be lost and regained.

We have destroyed the biosphere and reached a state of overshoot. We have broken the cycles these cultures experience and their wisdom is no longer relevant. For the Hopi, no matter how bad things got, people would survive and rebuild, the world would become stable again. This is not the case with our time, we have destroyed millennial long cycles, the end of many species, and potentially the end of all human life.

Hopi wisdom is not useful here.