I agree, the truly hopeless stories are not at all common in our mainstream media. I brush against them more in narratives that have smaller, more niche, audiences such as independent publishers of comics or novels, or plays that will never be Broadway-bound. I think mainstream media dips into the toolbox of despair from time to time to refresh their aesthetics or punch up a plot line but I don’t think we are in any danger of being overrun with shows and movies that end with all our protagonists bleeding out on the battlefield (rhetorical or actual).