Yes that tool is really cool and I admit thatit bothered me because of ACM ^^'
But just like the Anesidora which exploding not in its greatest capacity, I think it's not so compmicated to make it work. If Bishop was wrong, because he just give an estimation of the worst because he is not sure ? But the worst is 40 Mt. Plus you can add to this the fact that maybe the explosion was from above and maybe it was just a fireball above the colony and it didn't vaporised everything.
It would be more serious if none of the colony or the AP have survived. But here we know that the explosion happened, ACM didn't try to hide this to us. So for me it is not a problem, it's not like ACM ignored the events of Aliens.
We already try to find solutions for a story to be logical. This is a problem of science, and like I said before, there are many other scientific problems in Alien. Every SF films are more "fiction" than "science".
Explosions cause shockwaves and if it did come from underground like how they tried to claim, it would likely cause earthquakes, so the colony was have still had it. Though not an expert but I would imagine that should happen.
Except that is exactly what it did, which is ironic because it tried run on nostalgia. We actually see the explosion, it would have wiped the colony out and even the derelict, so yeah, it did ignore Aliens, multiple times actually.
ACM simply retconned things to make it fit, only you are trying to make it logica with mental gymnastics. This is not problem of science either, nukes will cause a large destruction of an area
, the problem is nothing to do with science and everything to do with a video game that just wanted revisit Hadley's hope and made a crappy excuse to do so. Nostalgia tends to cause problems with logic i.e Ray being skinned by an evidence cleaner just as homage.
Look, its great that you like the game but there is no point being in denial about the facts, ACM is a contradictive mess
, a person can like something even if its flawed and got major problems that can't be explained. So don't worry about it.