I wouldn't compare smoking to rock climbing exactly. It's the number one cause of premature death. One of every 5 deaths in the US happen due to smoking.
It's something that "probably might not happen", but it's really actually something that quite likely will happen. This counts too for pipe smoking. It's not a pretty death either, otherwise people would probably not give much of a shit. It's pretty gruesome and miserable.