It's still being sold.
http://www.direct2drive.com/12/153/p...Guide-Download
I would guess that most of Sid's games are not going to become abandonware for a very long time.
Edit: My mistake the link I posted above was just for the strategy guide
Sorry about that but it is still being sold on amazon
http://www.amazon.com/Electronic-Art.../dp/B00004XRBD It's one of their "classics" rereleases.