So by the time of Resurrection for whatever reason they couldn't get an Alien sample from it. This could be because it was destroyed at the end of Aliens, or at any point in the last c200 years. It could also be because there are no eggs left, they couldn't find it, some other group has total control over it etc.
Given what we saw in Prometheus with the ship ramming it directly and blowing up, it crashing down to surface I'd say it's pretty tough. I'm personally inclined to believe a spaceship could withstand extreme heat, and as such would have survived - although no doubt it would have been damaged to some extent.
I think the reason it wasn't directly addressed in Aliens was to leave it open for a sequel, in the end A3 didn't use it and then AR had to imply it was destroyed to lend credibility to it's plot.
With the new planet in Prometheus having loads of ships, and Paradise coming up the original derelict loses it's significance anyway - if they did a sequel in the timeline I'd expect they would get eggs from where else.