The second failure was a second stage exploding. Had the payload been a crewed Dragon V2, those inside would have survived. Even without a launch escape system, the Dragon V1 was fine[2]:
> The Dragon CRS-7 capsule was ejected from the exploding launch vehicle and continued transmitting data until impact with the ocean. SpaceX officials stated that it could have been recovered if the parachutes deployed, however the software in the capsule did not include any provisions for parachute deployment in this situation.
Overall, it's a much safer design than the Shuttle. The crew vehicle is on top of the stack instead of along side it. If anything goes wrong, the capsule can GTFO and land with parachutes.