There's a bunch research indicating that shame is not really a useful tool. Correlation with depressive symptoms etc. Hopefully anyone with kids should have realised that making e.g. toilet training more stressful, surprise surprise, is completely counter-productive, but who knows.

If the kid knows that they're not supposed to do something, that's enough - they experience their own internal feeling of failure strongly. I've found that the opposite is usually true, that kids never understand that learning things always involves failing a bunch of times, which is the imore important meta-lesson

Flipside, if they don't care about doing something wrong and you shame them, in my experience they often simply don't give a fuck. Maybe that's my own genetics though. Admonishment and punishment is more useful.