I think even if it's only usable in niche scenarios it would still be a commercial success. Superconductors are useful even when they're hard to use, as seen with existing cold temperature superconductors which a room temperature one could certainly replace and become a commercial success in doing so. With that said, you're likely correct that the first attempt won't catch on for mass adoption.