I also heavily disagree that "the players should always win" is a necessary design goal in RPGs.

The only issue is if "losing" and "death" are synonymous, it probably needs to be (effectively) true. The answer is, of course, don't make "losing" and "death" synonymous.