There's different types of "mistakes"

There's the mistake where a kid makes a physical error. There's absolutely no use yelling at a situation like that. Physical errors happen, and they either happen due to insufficient focus/effort during practice, or due to more or less dumb luck. Neither situation is benefitted by yelling during the game.

There's mental mistakes like jumping offsides or making the wrong play call. For the most part yelling is going to be ineffective here, but if a player has his head up his ass, yelling every now and again might be an effective tactic to renew focus. It should be one tool in the belt, but not the exclusive one by any means.

Then there are "mistakes" that are lack of effort, or actively doing something stupid, like taking a cheap shot. Yelling is almost entirely warranted in those situations.