I think sci-hub is wonderful. However even widespread adoption by students and academics won't necessarily cut into publishers profits.
"Gold Open Access" and so-called hybrid journals will still make money off academics who have to publish in them for status / tenure / just to get a job.
Elsevier etc could transition to make all their money off author / grant agency / institution pays type charges.
The solution[s] to this are things like Green OA journals, library led publishing projects like 'Open Library of Humanities' [1] and piracy / liberation at the point of consumption.