the term was created by casual basketball fans after the Big 3 got together in Miami... all they knew was that Lebron and Wade were on the same team, and they also got some guy named Bosh who was good in Toronto... I never heard that phrase used to describe the Celtics big 3, the stacked Bulls' teams, the Lakers or Celtics in the 80's, etc.
It's a misnomer really, the only "super team" I can think of is those Bill Russell led teams back in the day that had like 8 Hall of Famers on one squad... but as far as modern day basketball is concerned, the way the league is now, you NEED to have a stacked team to win multiple championships (Hakeem's Houston teams being the lone exception)