Training to failure has its benefits, particularly in strength/weightlifting areas, overtraining can cause rhabdomyolysis and other issues but that’s usually from a combination of factors like nutrition, rest, sleep, proper form etc it happens more often in HIIT exercises where someone might be training at an extreme pace

FWIW I’m just some guy who exercises, take this with a grain of salt