He seemed to be in denial about his drinking, I think often when he was clean from drugs he was replacing it with alcohol, and considering that to not be as much of a problem.
I really don't see STP ever getting into the Hall of Fame, problem being, they just aren't that famous.
They were, but they are no longer a household name like a few of their other peers. They didn't combust in a blaze of glory like Nirvana, and they didn't stick around and carve out a steady reliable career like Pearl Jam either. Even once he got with VR Scott's resurgence was shortlived, and the press quickly went back to reporting all the shit he got up to until they got bored of him completely, and the rest of STP were never of much interest to the press at all, not being mercurial stars like Scott was initially.