tl;dr this happened to me about a week ago, and replacing the headlamp soled the problem.
I have a 2022 Niro Hybrid, and the headlight check warning came on while driving; the next morning it was totally dead. Discovered the 12V reset button (WOW the manual could do a better job pointing the reader to that before jump start) and got the vehicle started. Expected a small child had left a light on, but I checked each one and that was not the case. Drove it around to charge the battery - but was dead again the next day.
My neighbor who was going to help me jump it said that modern cars will sometimes disconnect the battery if they sense it will run out, and the button maybe just reconnects it? But we don't know for sure; the manual did not explain it. That said, the button is great to have, a sort of self-jump!
After needing the button every day or two, I had time to replace the headlamp and that seems to have solved the problem (it's been about a week, which would have been 3-6 button uses). It's weird to me that these two things are interconnected, and that it doesn't seem to be very well known issue if they are.