How is keeping the job you already had a reward for failure???
Promoting him would be a reward for failure.
The chances of him repeating his 'error of judgement' must be slim to zero, and therefore all his training and experience has gone to waste.
The easy option is sacking him and that's the bottlers choice.
I'm out of this now, got nothing further to add.