What happens to DB public sector pension on death

That option is no longer available. The trade off is that a spouse acquired, or a child sired, post retirement is now entitled to pension benefit following the pensioners death in retirement.

However, there still is, I believe, one exception. If you are professed to a celibate religious life, you are still eligible for a refund of spouses and orphans contributions. Yes, seriously!