The late night TV series aired 450 episodes for nearly a decade and was often the only opportunity for music fans to see their favorite recording acts perform