I don't think a high failure rate even matters. If only 10% of billion dollar projects succeed, then spending $10 billion should get you something equivalent to a working human brain simulation. And hopefully at least something is learned from the failures. Even they don't succeed at building a human brain doesn't mean they don't learn anything.
I think the main barrier there, though, is that funders have to be in favor of interesting failure. With the described mega-science funding project, there's a big incentive to come up with dramatic plans that are novel and promise certain success.
I think the tech industry isn't perfect at this; we can all name companies that spent way too much money for what they learned. But our FFF/seed/A/B funding model gets us a good discount on interesting failures.