From Abba to Zamballarana, and from Mozart to Eminem, one of rock’s finest talents has identified 500 albums essential to a happy life. It was a long, tortuous undertaking, but the man knows music (and his aim is true)