That is what I mean when I say that script deaths are one of the exceptions. In your case, the player willingly chose the death. That is good story telling. Dying because GM miscalculated the challenge rating, on the other hand, is not.
I am not opposed to death, I am opposed to meaningless death.