well in answer to the original query, i think it is a major limitation to its wide use.
the prohibitive cost and the advanced technology to establish such a system widely as well as the expenses in maintaining the material near critical temperatures is a sure limitation...
and yes, there are other auxiliary limitations or flaws if u will
- there is a maximum current density above which the superconductor resorts to being a normal conductor despite how cool it is
- there is a critical magnetic flux density above which the material stops superconducting, again...
- ceramics, or high temperature superconductors are relatively cheaper to put to wide use because of the higher temperatures required, but as has been said, their brittle nature means it would be hard to draw them into wires...
EDIT: auxiliary doesn't mean that these aren't important points. These are equally important limitations.