I'm not an expert here. But I think all these tanks are made to hold way more pressure than they're rated for (3000-4500 psi) and made to last, probably in the case of aluminum, likely for lifetime use.
airgunmike56 described a scenario of a slow leak in a CF tank. Just from my mountain biking and lacrosse days, I'm a little more wary of carbon fiber versus aluminum. They can both crack, but aluminum to me seemed a little more predictable in how it would happen at obvious weak points. I never quite learned how carbon fiber tends to fail, but I do know there were plenty of stories of people's gear failing in unexpected ways.
To hear that his tank failed "gracefully" is encouraging. I wouldn't count on it in every case. But I do sure hope these tanks are designed to fail in a relatively safe manner. There is no reason to believe that one of these tanks will suddenly explode like a bomb. I've never heard of that happening, and in the most cases I think you should be able to detect if a tank needs to be replaced.
I don't have any carbon fiber tank guns (someday I might) but all these aluminum tanks I plan to leave at full pressure until I start hearing if there are any problems doing that 10, 20, 30+ years down the road. In most cases I doubt it.