From personal experience - no it won't. I have made mistakes with overriding warnings - when under pressure, hyper focused and already in the mental mode of - of course I am sure I want to do it - your slow brain is just shut down so you are moving a bit like on muscle memory.
Simply add a 1 hour unskippable countdown timer to the warning. Now you have to think about it.
If you have one hour you shouldn't be editing live anyway.
From the many depressing years I've done UX work I can promise you no amount of changes they make will protect users from their own mistakes. It is far better for your own sanity to accept people make mistakes. This is what development and staging environments are for.
Accepting that people make mistakes is one thing, but reducing those mistakes is another.
If it’s a simple change, why not do it? Though, I can see your point if the change is monumental but barely reduces rate of mistakes.