Nicotine overdose would be more common if people injected it. Smoking heroin isn't actually that dangerous (though admittedly, more dangerous short term than smoking tobacco). Why don't people smoke it then? Because the illegality makes it really expensive, and injecting is more effective.