William Eggleston’s photographs were once voted the most hated of the year – but this new retrospective proves just how wrong critics can be