Stuck on alert (and hdmi issues)

Reflashing the SD card is exactly the same process as when you first set it up, and this will fix this issue.

As for what you can try before pressing the reset button in the future: