How does it say the Space Jockey was destroyed?
Sounds to me like the most recent source (the RPG) is deliberately vague on the topic.
That also happens to be what Andrew Gaska confirmed when I asked him about it a little while back.
Also the WY report doesn't say it was wrecked, merely that it was a "non-viable source" as of the timeframe of the book (post-2381).