Last I checked two characters living isn't everyone dying. It's not like this is meant to be a happy story although it isn't a complete tragedy either. If you want a happy ending then go watch a Disney movie or something.

And I wasn't talking about you hating it just the general consensus of many Alien series fanboys.

Story wise I thought it was great. Plot holes are only problematic to me if they're not deliberate. I do wish some things wouldn't have dragged on and Hollaway's character was less of a twit.

Also the Captain didn't let two people die without explanation. I think you missed the part where they said they will choose to stay on the ship to help him fly the ship to stop the Engineer's attack on Earth because he was going to destroy it. They succeeded so all three of them were martyrs but an heroes as well.