Here is the Alien trailer in question.
If the noise is an element putting you off from watching this film I should point out that it was not a feature of the other film (which I would highly recommend not just because I admire it but because it's an important and influential piece of cinema which you deserve to form an opinion on).
I doubt if it will appear at all in Prometheus and by all accounts the explosions are a minor feature of it.
Screams of terror and pain are more likely irritants to the eardrums of patrons.