A magnetically vibrant keyboard prodigy who played on Let It Be and worked with George Harrison, Preston later lived through years of addiction. A new film aims to find ‘the dark and the light’ in his story