Gigs already said the fossil behemoth was a suit. I believe David seeks godhood in future movies and ends up to become this giant hybrid synthetic engineer who gets chestbursted. Its already hinted at in Fire and Stone with Elden, the synthetic who got exposed to the black goo, turned into this giant engineer synthetic. David is the fossilized being in ALIEN. Watch as Ridley Scott makes this into reality.