Designed correctly, there is potentially a whole spectrum between "complete success, desired orbit" and "fire-y ball of death". As other commenters here have pointed out, one of the Space Shuttle's fatal flaws is that it severely narrowed that spectrum (even one of the
supposed "abort modes" probably wouldn't have been survivable).
So far, everything SpaceX has done is working to greatly expand the window of "survivable failure". Remember on one of the early Falcon 9 flights when one of the 9 first stage engines literally disintegrated and the rocket kept flying? How many other rockets flying today can do that?
So, no, I don't expect we'll see people die in a SpaceX capsule. When was the last time someone died in a Soyuz?