The idea is that potential criminals, seeing the severity of the consequences in vivid reality, will be more reluctant to execute their crimes.

Yup, & every study that's ever been done has indicated that the death penalty is no deterrent whatsoever.

Except, of course, to the person executed.

Unless he/she is a zombie, werewolf or vampire, I suppose....