On page 5 of the following write up, the author asks why the Bourbaki did not notice that their system of Zermelo set theory with AC was inadequate for existing mathematics. Throughout the rest of the discussion, the author asserts that the Bourbaki group never acknowledged Godel's results on incompleteness or Russel's paradox.
However, from the introduction to their Theory of Sets, one can read:
To escape this dilemna, the consistency of a formalized language would have to be "proved" by arguments which could be formalized in a language less rich an consequently more worthy of confidence; but a famous theorem of metamathematics, due to Godel, asserts that this is impossible for a language of the type we shall describe, which is rich enough in axioms to allow the formation of the results of classical arithmetic.
And further,
Indeed, this is more or less what has happened in recent times, when the "paradoxes" of the Theory of Sets were eliminated by adopting a formalized language essentially equivalent to that which we shall describe here; and a similar revision would have to be undertaken if this language in its turn should prove to be contradictory.
So, is Theory of Sets by Nicolas Bourbaki as outdated and obsolete as A. R. D. Mathias suggests? If so, how does that affect the subsequent volumes, if at all?
Ideally I would want to read several of them by starting, for completeness and coherence's sake, with vol. 1, having already a solid grasp of basic set theory (at the level of Hrbacek & Jech), after making the connection with mathematical logic (at the level of Enderton) and derive other theories from there (in the spirit of the Bourbaki's), for a personal write up.
Edit: For those stumbling on this, Mathias does indeed seem to overlook several elements indicating that Bourbaki were very well aware of pretty much everything he calls them out for. I recommend reading all the historical notes interspersed within Bourbaki's Theory of Sets, especially the very last one which is quite informative.
You may want to read this critical review by S.L. Segal of that essay:
https://zbmath.org/?q=an:00096766
As Segal points out, Mathias is mostly raging against the neglect of set theory, logic, and foundations as worthy subjects of study. In a further response to Segal's review Mathias admits that in his essay he was not attempting to be a 'sober historian'.
Altogether that essay is more or less a personal rant, not serious academic output. It is an invective against Bourbaki-influenced mathematicians for not taking logic seriously. It blames Bourbaki for the dismissive attitude towards mathematical logic and foundations that exists in the mathematical community. Mathias laments that Bourbaki did not deem Gödel's work as worthy of being included in a volume on set theory. This is what he means by Bourbaki's neglect of Gödel, not that Bourbaki's Set Theory is inconsistent, but that it's not an in-depth treatise on mathematical logic.
For academic purposes you can safely ignore any mathematical concerns in that essay and not be any worse off for it. You can likely find much more serious critiques of Bourbaki addressing similar concerns.
Bourbaki's treatment of set theory and foundational material is outdated. It's only meant to provide a solid starting point for the 'real math' in the subsequent volumes, not to study set theory in itself. For its own purpose it is entirely adequate.
One of the shortcomings of Bourbaki's Set Theory as foundations for math is that there is no mention of categories anywhere. Instead it uses rather contrived constructions such as 'structures' and 'species'. This language is now almost entirely extinct. Additionally, for ideas such as 'adjoint functors' there are no alternative constructions offered at all, and they are entirely absent throughout the volumes.
Don't read Bourbaki's Set Theory if you want to understand set theory as a mathematical field. Personal interest or wanting to understand Bourbaki's at-times arcane language are better reasons to look in that book. In any case it's not a very difficult read, but it contains extremely convoluted constructions for basic mathematical objects, and many of these constructions are meant to be forgotten once their existence is confirmed.
In fact for learning math it's probably a good idea not to read too much Bourbaki. Reading a few passages here and there is likely beneficial, but reading the entire series from beginning to end is probably a waste of time, as each of the general topics covered have advanced since and have their own modern canonical textbooks.