Beyond: Two Souls is a story driven game, not an exercise in forced experiences. As such, even if you let the protagonist die, you won't see a 'Game Over' screen. The story doesn't come to a complete stop, but rather, new doors open.