I figure this WILL have an appeal to the general market in the same way it did before with Voodoo 2's... It guides you to buying a particular card early on for a good upgrade, and then get another of the same card later when they're cheap as an easy upgrade later on, rather than shelling out a ton for the "next, greatest" thing of that generation or next.
It WILL, however, take a long time to roll out. PCI-Express itself isn't precisely common yet, and though it's coming it will require a dual PCI-Express board (which in itself will cut down on available other expansion slots and restrict cooling options somewhat, which the power gamers like--but won't affect mainstream much) to be purchased first (or as an additional cost later, which drives some people off), and it will ALSO require PCI-Express, SLI-capable boards that are in the mainstream already, rather than the $400-500 cards which area already in a small market.
In one-to-two years' time it might start filtering down to more maintream options, but for now I think we'll mainly see it as a marketing point and way to interest the real enthusiasts.