Pretty sure average life expectancy has gone up since soda was invented ;)

Pepsi would not want its logo on a tombstone even if pepsi was good for your health and everybody knew it.

Few companies want you to think even in passing "this guy used their products and now he is dead"

The general trend yes, but compare the population of water drinkers against soda drinkers and I bet you won't find a positive correlation.