I was reading in my county newspaper that here in Pennsylvania only three people have been executed since the state resumed capital punishment in the mid-1970s. Most of the hundreds on death row die of ailments, usually those associated with old age. So, California would not be a lot different.
I know that Manson got sentenced to death and then ended up with life in prison after the penalty was abolished. I think that death would be good for him and keep his cohorts with life in prison. It seems to make them suffer more that they live in prison and considering how they keep trying to get out, I cannot imagine a more exquisite form of torture for them.