George A Romero’s adaptation of Stephen King’s novel has all the elements of another breakaway smash for the director. Sadly it doesn’t quite work out for him