The legendary music executive helped launch the careers of Whitney Houston, Janis Joplin, Springsteen, more