They also add some pink noise from the air and motors which might help.
In any case, just an idea, data on their effectiveness seems hard to find.
If you can’t launch a surprise attack because the audience will give it away, the best strategy would be to slowly and incrementally build up a gold and experience advantage.
A certain player who used to get accused of cheating a lot learned this trick way before everyone else, but in recent years everyone's been doing it and it can really swing games in a way that's not fun to watch as a spectator.
Later versions of the client added an option to mute those sound effects, for precisely this reason.
Think of it this way: any time the audience starts going wild about something one team knows about but the other doesn't, they're doing so in anticipation of dramatic moment when the other team learns what happened and must adapt while the first time is trying to exploit it.
If it's given away instead, the anticipated event never happens or is muted because the enemy is not caught off guard.