A large part of SpaceX’s success in winning commercial crew approval is because the stack is actually very traditional. The primary innovation is first stage recovery which arguably doesn’t add any risk to the crew.
Fully new materials and propellants completely change the game when it comes to risk. I hope the succeed and I think they can succeed. It’s just that this round is going to take a little more money than the Falcon/Dragon program and I hope they’re able to find enough of it.
As for human rating Starship - I think the best bet is to launch them as many times as possible unmanned to demonstrate it is safe, kinda like the thousands of flight hours needed to certify a new airliner. This should be perfectly doable on the fully reusable Starship + Super Heavy combo.
I'm not saying rad hardened aerospace computers and specialized programming languages (ADA and co) are bad - there was a time where they were absolutely the best (any only) choice, but thankfully today there are often better options.
IIRC for the Dragon computers I remember an article that mentioned that if they went with aerospace computers, even just a devkit would have cost >150 thousand dollars, severely limiting available resources for developers and the flight hardware would have lead time in years.
So they went with redundant (IIRC 5 times) x86 with Linux on top & each engineer working on the code can have effectively flight hardware on their desk for use during development.
In that regard, FFSCC rocket engines actually remind me of LFTR-type MSRs:
1. been around for decades
2. clear benefits to the design
3. hasn't managed to be used viably
So I would say Starship + Super Heavy is definitely a riskier investment than NASA has made with Falcon.
(1) no one's used methane on a rocket before, so there's not a lot of experience in ground handling it, and its properties are rather different than other fuels.
(2) Making large lightweight steel pressure vessels is also rather novel.
Those two account for most of the destruction; the rest are the sorts of errors usual to a rocket test program. It's an industry famous for blowing things up due to low margins and lots of potential energy.