Sometimes when uploading through a weak connection (WiFi) it fails mid-way. Then the target is locked in some sort of loop waiting forever. The only solution is to trek out to the remote device, unbolt stuff, hit the reset button (or cycle power).
If i read it well then this case will be solved with the latest esphome builder update. The change log stated that there will be an automatic rollback when ota fails and a valid reboot isn’t reached.
This sounds like newer behavior (or something unique in your setup). I know in the past (it’s been a while), I had a couple devices on the edge of WiFi coverage that would usually take a couple of OTA attempts before it could finish the transfer. I definitely never had to manually intervene, I’d just ‘re-compile’ and try again immediately.