I remember the line from the first time I saw the movie, and noted it, and that it absolutely did not adequately prepare me for the level of insane stupidity/incompetence/outright perverse behaviour that I went on to witness.
Like screw-ups to me, means people are kooks theory-wise, drunks/drug addicts, people who got someone killed by being lazy or distracted or not following procedure, serial sexual harassers, etc., and whilst we get like, kind of a nod to the former with the implication that two archaeologists are considered kooks, none of that really implies the basic level of incompetence and just bad-brain-based-stupidity we witness. It's like "Scary Movie" levels of character behaviour (that's probably an insult to Scary Movie). Also the movie when goes to huge lengths to assure as that said kooks are not kooks, they're Visionary Geniuses Maaaaaaaan.
(Also, "crew of screw-ups" is a classic trope, and never before has it meant "Basically the Keystone Cops" in an action or horror movie.)
If people did dumb things because they were high, or had some specific problem that caused them to screw up, you could have quite an effective horror movie, if a predictable one. But that's not what happens in Prometheus. Instead people just run around like morons for no explicable reason.
That seems like it would have made for a much more interesting movie!
But Ridley Scott is only interested in blowing smoke up his own arse. The entire construction of Prometheus is not as a horror movie, but as an opportunity to express some silly ideas, that reek of, I dunno how else to put this "shallow thinker who read too much pseudo-science and pseudo-philosophy drivel in the 1980s, snorted too much coke, and thinks he's a philosophical genius". The movie definitely thinks it has Big and Important things to say, Scott basically said as much - he was very clear that he believes Ancient Astronaut naughty word note - it's not in the movie merely as a plot device. It's the sort of thing Scott actually believes.