You do understand that this game takes place, if I recall the videos correctly, after Alien3 with story elements that explain what happened after Aliens which does a better job of explaining why Alien3 happened.
While the movie you are referring to takes place before Alien if I recall the details on that correctly.
I dont think it will, honestly. As far as i know, this game has been in on again off again development for like 10 years. It'd be cool as hell, but i dont see what theyd work in outside of giving you some tall guy to shoot every now and again.
Odds are good though that the vast majority of the plot was written before prometheus was officially announced.
I just saw Prometheus today. The only link this game might have at all to it (and that's by retrospective coincidence, not deliberately) would be if we get to visit the derelict in the game, but I wouldn't hold your breath if you're expecting giant statue heads, deadly black goo, or living engineers.
"Oh I will, I'll shout if that happens, yes... something like... 'I WAS NOT EXPECTING THIS!'" The Doctor