We, as fans, tend to grossly overanalyze things. There are tomes of fan theories and people doing math to "prove" all sorts of things that did or didn't happen on screen and to infer rules from them. But, if we look at it like movie creatives, writers, directors, and producers, that all goes out the window.
If they want the Derelict to still be there in a sequel, as the source of Alien Eggs, they will simply have it there and say that it was far enough outside the range of the blast to the extent that the eggs are okay or based on the durability of the Juggernaut ship, or whatever. They would simply ignore the fact that WY would have gone there right after the events of A2 instead of tracking down Ripley in A3, as they know this will not occur to most of the audience.
The same way that James Cameron ignored the fact the Derelict ship still had its beacon on after the events of A1. Yes, it was addressed in Alien: Isolation, but that was filling in a plot hole three decades after A2 was released. That plot hole didn't prevent the vast super-majority of audiences from enjoying the movie.
As far as the specific statement of "the size of Nebraska," all hinges on whether Bishop was, or was not, using precise language. He might be programmed to speak for effect so that he sounds more human. The point he was getting at was that they all needed to leave, as they couldn't hide from the explosion. Not to educate them as the the precise size of an explosion. - Now, we could debate all day if he was using precise language or not as an android, but I'm not interested in such a debate. My point is that if 20th-century studios want to use the derelict again as the source, then that is how they will treat it, regardless of what was intended by James Cameron at the time.
The expectation of perfect consistency will never be something the studio delivers on. That goes double for shots that didn't make the final cuts of movies and related materials from novelizations of scripts. They are focused on making relatable characters to draw the audience in. They cannot even get that right half the time either, so expecting perfect consistency to things we over analyze is an ask "the size of Nebraska."
