> If people smoke and are unhealthy they in theory would need a larger amount of prescription drugs which CVS sells and profits from.
If people smoke and die sooner, they will in theory (and practice) need no more of the prescription drugs which CVS sells and profits from. Heck, statistics showing that smoking reduces total health care costs (and, less relevantly to the immediate discussion, pension costs) by killing people younger have been used by cigarette smoking companies as part of campaigns against government anti-smoking campaigns around the world.
Aside from the moral aspects of that argument, the financial aspects work exactly the opposite for people selling health care services -- which CVS does, both as a pharmacy and a clinic operator -- as they would on people funding health care costs.