i.e. - It has zero resistance to electricity.
Currently, the best superconducting materials we can create have to be chilled to near absolute zero, which means designing them to work in liquid helium baths. This is expensive, and difficult. If a material can superconduct at room temperature, now we're talking usage in general purpose consumer goods.
As for why we want a superconductor? Real cool stuff happens when there's zero resistance to electrical current. I'm sure other people can add on to this, but for an immediate benefit - electricity transmission wouldn't have any losses. Imagine offshore wind turbines that could transmit power to Kansas from the Atlantic. It'd be a big deal.