That attempt famously and spectacularly failed with Gödel's incompleteness theorems.
Since then it seems that mathematicians have lost interest in foundations and are content to search for interesting results, structures, and systems, even if they don't have a solid foundation.
More recently I've heard some proposals to revisit the foundational project but with higher-order logics proving the consistency and completness of lower-order ones, which sounds interesting, but I'm not sure how much progress has been made, and to a non-mathematician/non-logician even that attempt sounds a bit like a house of cards.
Does anyone here know about this and if there are even any mathematicians around these days who are still interested in it?