I think it depends on a lot of things. Individual sympathy is very different to me than social-level sympathy for the issues that we've known for decades now raises the risks it like homelessness, early repeated exposure, familial and community encouragement, and so on. It's be nice if prevention of alcohol addiction was as acceptable to talk about as smoking, but sadly it doesn't seem we're there yet on a society level.
Oversimplifying it yeah, but for me it's similar to the smoking example from Inextremis, the old & quiet user from before we had a lot of the research into it, where they feel it's one of the few pleasures they have left, I do feel for them. Those who are trying and struggling to reduce their use and/or its impact on others with trauma and limited resources yes.
The violent person who thinks their drinking or other drug use can be used to excuse their horrible behaviour, the user who thoroughly enjoys both their own use and in trying to push others to do the same, no. I see no reason to feel more sympathy for them that someone who does the same shit without drink or drugs. It may lower inhibitions, but it doesn't change who someone is as much as popular narratives like to suggest.
I may not entirely agree with the paedophiles comparison, but many addict parents push their drug(s) of choice onto kids and others, abuse kids and others, kill kids and others, so yeah, the question has some merit. In the same way, adults and communities who turn a blind eye when they know it's happening get my ire. I've seen 11 year olds blackout drunk with no repercussions for the parents because 'kids will be kids' ignoring where they got the drink, I've seen little kids given alcohol in quantity because it's 'funny' and 'they have to start sometime', as a kid I had to protect my drinks from my own family and I had to deal with dozens of adults refuse to stop my obviously intoxicated mother from forcing me into a car for reasons I will never understand. I nearly died that night, she wanted me to die that night, but ~she's going through a hard time, you have to be understanding~. No, I don't. It doesn't help anyone if I try to be sympathetic and understanding about people like her.
Like the old saying goes, if you are kind to the cruel, you will end up being cruel to the kind.