The provess needs to improve but the query didn't run itself, leaving the person in their position but giving them what sounds like a light chewing out isn't a sign of bad leadership.
I think the correct thing to do no matter the scale of the fuck up is you, as the person doing the confronting, admit to what you did wrong that led to this outcome, as well as addressing what they did.
They didn't do that, and they threw around "you" a lot at an "us" problem. That's bad leadership.
Leading by example means readily admitting to your own faults and acknowledging that the team has a shared responsibility for outcomes.
The provess needs to improve but the query didn't run itself, leaving the person in their position but giving them what sounds like a light chewing out isn't a sign of bad leadership.