Although I presume the loss of revenue from that and the (hoped for) decline in alcohol consumption would be offset by the lessened cost of healthcare.

But, to be bleak about things, I wonder how the costs incurred by the health problems brought on by smoking and drinking match against the costs of simply living longer because you don't smoke and drink. Mortality is complicated, someone find an actuary and a health insurance assessor!