As yet another exhibition opens, Dale Shaw argues that the Pop artist’s finest work was The Velvet Underground and not churned out, over-hyped prints of soup cans and celebrities