Comment This is rocket science (Score 4, Insightful) 46
Space is hard. Aside from the heat shield, there are a million things that could go the wrong with loss of life as the result.
With the Mercury, Gemini, and Apollo programs, by the time Apollo 11 launched, they had done a pretty good shakedown of the systems, and lost three astronauts during that shakedown. If this were SpaceX, there would have been at least two, maybe more, unmanned flights testing all of the changes between iterations. Here there was no iterations. Artemis I flew just over 3 years ago. There were anomalies noted in the heat shield, they did root cause analysis, came up with a fix, and that fix is now flying with humans on board. In SpaceX's world, there would have been one or two (or more) flights in-between Artemis I and Artemis II to validate the fix, rinse and repeat.
The whole Artemis stack is a one-off rocket using 1970's technology (Shuttle type engines, tank, solid boosters) and it takes a very long time to put one Artemis stack together. This will be the second flight for the Artemis stack. Granted it is based off of old technology that has been mostly proven from the Shuttle era, but it isn't a stack that has been a workhorse like Falcon 9 has been. So there are lots of things that can go wrong with things that are not in the forefront of anyone's thinking.
Space is hard. This is rocket science.
The real concern here is if anything does happen that either leads to an Apollo-13 like situation where the crew barely makes it back alive or the crew not coming back alive at all, it could lead to the US not being the next nation to land people on the moon. It would take years to recover from a catastrophic failure, which will leave the US far behind China in the race to put a new set of boots on the moon. Apollo 1 and Apollo 13 incidents happened due to causes that no one was really thinking about, until the incident actually happened.
At the end of the day the risk will never be 0. The astronauts and NASA both know this. We can reduce the risks we know about to a point where people are willing to take the risk. But its more the unseen risks that, IMHO, pose the greater risk for failure.