Like any bike that's been sitting for a couple decades, it will need an overhaul to be properly functional: new tires, cables, housing, and fresh grease in the bearings. Possibly other problem spots like the brifters, as mentioned.

But the bike itself should be good forever.

As suggested, I'd recommend getting rid of it if your only other option is to let it slowly rot in storage.