In my experience most Catholics would go along with the Pope in opposing the death penalty, and my impression is that this is fairly general in Europe. It may perhaps be different in the USA.

When there was a referendum on the death penalty in Ireland a few years ago, people voted in favour of putting the ban on capital punishment into the Irish Constitution.