Despite big names, high expectations and a short shelf life, The Firm proved that even rock supergroups can fall flat.