While it is true that pros do ride carbon fiber (CF) bikes, what the world doesn't know is that they get a new bike twice a season assuming no crashes, what the world also doesn't realize is that the race bike, not the training bike, only sees around 2,500 miles in that 1/2 season time frame. For the rest of us that means every time we wear out a set of tires we would be getting a new bike!! So, yes, failure happening on the pro race circuit is reduced because the bike is not kept long enough to introduce fatigue which is why they get rid of them so as not to endanger the riders unnecessarily. The interesting thing is that I cannot find any information about any bike crashes caused by frame, fork, or wheel failure, they only report crashes involving peds or cars or slide-offs, the rest are hushed.
Now riding an average mid-price CF bike for the average person is not usually a problem, getting 10,000 miles on one is nothing, and getting 150,000 miles on one is a whole other thing. Steel (ST), and titanium (TI) are very well known to far exceed 150,000 miles with the average rider. One of my steel bikes has over 160,000 miles on it and it still rides fine.
One comment had this stuff backwards; while aluminum will dent at first, then bend, and finally break, carbon will crack at first and then break. This means with aluminum, you’ll notice the warning signs while it would be somewhat sudden with carbon (especially, if you don’t inspect your bike carefully and regularly) and even without a warning. Most damage to CF stays hidden from outside view because it delaminated or splintered, or cracked on the inside of the tube wall.
This is why CF bikes all have a weight limit, granted, most of that weight limit is in the wheels not the frame, but one frame is designed to be a tad more robust to weight than the wheels are, but not much more, maybe another 20 pounds more, so if a wheelset is rated for 220 pounds, the frame is usually rated for 240. When I bought my Lynskey, a TI bike, I rejected the Lynskey CF fork before I took possession of it because they could not tell me its weight limit, so I opted to have an Enve 2.0 fork installed instead because it was rated to be used on tandem bikes, meaning it can carry a lot more weight than 240 pounds. But I only weigh 175, so the standard fork would have been fine, but this CF stuff can be tricky stuff, so by getting a fork over-engineered, or far overrated for my weight I'm confident it should last a lifetime of average use bar any crashes.
One of the big indicators as to how weak CF bikes are is that it is REQUIRED if you are tightening any screw or bolt, nut, clamp, etc that you use a torque wrench, failure to do so could cause over-tightening, and when that happens you will crush the fibers which will eventually lead to something breaking. This might be the biggest reason why CF seat posts and CF handlebars fail, but even screwing in the bolt to mount a water bottle cage can damage the frame if it's done too tight.
CF is strong as long as it is used within it's design limits, and each bike will have different limits, the real expensive $10,000 plus CF bikes will be less durable due to the measures taken to reduce the frame weight by making thinner CF walls, then a $3,500 CF frame that will be heavier and thus thicker tube walls. Also, generic direct from China CF stuff is the worst stuff you can get, stay away from those, don't let the low prices blind you or it could kill you.
Google: How to Tell If Carbon Bike Frame is Cracked? [Answered 2022] - Cycling Revolution
Google: Why Carbon Fiber Bikes Are Failing (outsideonline.com)
Google: Cyclists falling victim to an undetected danger with their bikes | The West Australian
This guy is a well-known CF engineer and repairs CF bikes, he knows his stuff; Google:
There is a lot more out there regarding the problems with CF, what I showed is just the tip of the iceberg.
I use to have an aluminum bike, and it was a problem child, it developed a crack at the top of the headtube and radiated down from the headset, the bike manufacturer would not honor the warranty because they said it was due to fatigue and that isn't covered...fatigue? The bike was less than a year old, with less than 4,000 miles, but it would have cost me more to fight the case than just to buy a different bike.
I have several steel bikes, and a titanium bike, never had a single problem with either, even a friend of mine bought a very inexpensive Motobecane TI bike and his bike has been great since 2011, he did have to replace the fork though and got the Enve 2.0.