Compact discs provided the soundtrack to his life. Then came streaming and he couldn’t get rid of them fast enough. As CDs enjoy a renaissance, our writer looks back at what he lost