In his 2000 adaptation of Hubert Selby Jr.’s novel, Darren Aronofsky creates a disturbing vision of isolation and addiction that remains just as today, writes James McCafferty