All that can be said of Circuit City and Best Buy is that they are barometers of what the mass market is buying.
Like it or not, Joe and Jane Normal aren't going to pay $30 for what they are told is a "better" CD. Their desire is for a handheld device that can hold 4000 CD's, and the audio quality is almost entirely irrelevant to them.
Really, the only surefire omen that SACD is doomed is that it is Sony's baby, and Sony has a long and proud history of dropping the ball. ;) Although, in all fairness, DVD-A is a pretty big non-event to the general public as well.
On the other hand, there are many small specialty labels, such as Channel Classics in Holland, that have dived into SACD with both feet, and are doing great work, not to mention bigger labels like Telarc and Deutsche Gramophon who are pressing in CD, SACD, and DVD-A. It doesn't hurt to cover your bases, for sure.