In the game of folly versus lolly David Lynch's version of the Frank Herbert science fiction novel Dune played and lost. Now revived as part of a BFI Southbank retrospective on the director, it is often regarded as a patchy, incomprehensible failure. Andrew Stimpson challenges this consensus