> PhD mathematician in industry here. The way I see it, foundations is to the rest of mathematics the way music theory is to music: it needs to be a describer, not a prescriber. (If I were less charitable I'd have said "ornithology is to birds").
That sounds nice, but breaks down when one thinks harder. Music is a little bit physical phenomena, a little more biological phenomena, and even more cultural phenomina. That's many layers at once, and theory has to conform to the evidence.
Math, is not science. This is no evidence external to reasoning. Different foundations / formal systems conclude different things.
At best, we can look at what matches existing working mathematicians mental heuristics and.....that's not ZFC, which admits all sorts of crap because it is untyped.
> On the contrary, ZFC has been a tremendous success in that most mathematicians don't need to worry about it at all.
That is how most mathematicians see it, but us in the type theory crowd see that as bad goalposts necessitated by the fact that ZFC is so clunky to work with --- of course one wants to declare mission accomplished and move on to other things as quickly as possible with a foundation like that.
Check out https://xenaproject.wordpress.com/ for a less heterodox approach, that nevertheless does use a type theoretical "user interface" and "kernel" (trusted foundation) for purely practical reasons. Basically, the idea is making making formalized mathematics not a huge burden necessitates a more ergonomic system than was needed 80 years ago without computers.