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