I agree and it’s not the only alert that seems counter to its purpose.
The bedtime notification haptic is similarly harsh and has actually woken me up before when I was super tired and went to bed a few minutes before my scheduled bedtime.
The low battery alert keeps the watch screen on at full brightness until you dismiss it.