Edwin Frank’s survey of 20th-century fiction stresses the po-faced seriousness of the great novel. But many masterpieces revel in the ridiculous – or are about nothing at all