It was very real. One of the reasons there was not widespread failure was due to the creation of software that scanned for two digit dates and fixed systems at scale. That and people spent years preparing for it. A few systems failed, but nothing on the scale of what was predicted.