I think Deathward was more useful back in the "good old days" of instant player death being a core mechanic of the game. I know Deathward was invaluable to getting the "No One Died" achievement on the Enhanced Edition of Baldurs Gate 2. Now that player generation takes so long and deaths are far less common, I doubt Death Ward sees nearly as much use. So much of it is nostalgia, like this thread from 2013.
God I miss 2013.
With certain campaigns it’s still a big thing. A lot of high level undead with level drain are a major threat otherwise can be negated. When you know you’re in area with undead it’s usually a good spell as it’s cheaper than having to spend multiple Restorations plus diamond dust.