A good documentary here about Operation Chastise:-
Any Operation needs a certain amount of luck, ie a lucky hit on the Bismark's rudder etc. Chastise seems to have lacked that necessary ingredient. It took 5 mines to breach the Mohne Dam, another 3 for the Eder. The Sorpe was not breached, and it was known to be the most difficult of the three being of earth rather than masonry construction. It was also the most difficult to attack, as Wallis required the crews to release the weapon by flying along the dam rather than approaching from the lake. In the event, thickening fog over the dam made for a far greater defence than the Wehrmacht ever could, and aircraft had to divert to secondary targets rather than persevere with the Sorpe.
The Sorpe was the Achilles heel of Chastise. If it had been breached then Ruhr production would have been severely affected. As it was it got by, and thanks to a swift and effective response it was soon back to status quo with the repaired Mohne Dam.
None of that means that Chastise should not have happened, but it seems to bring out the same gainsayers as have an agenda with the Strategic Bombing Campaign itself. Terror attacks, poor use of resources, unacceptable loss rates, etc etc. What they can't say is what the situation would have been if the RAF had not gone out night after night bombing German cities. Unhindered, Hitler had enough cards up his sleeve to have made the outcome uncertain to say the least if he had been allowed to play them. As it was he was within months of some and actually launched many V1s and V2s anyway.
I am not surprised that the Army (which still doesn't understand Air Power) and the Navy (which does but only in a Naval scenario) had issues with the CBO, but when the RAF itself has an ambivalent stance to its own Bomber Command campaign, that I cannot understand.
You don't win wars by staying on the defensive, yet Bomber Command was the only one that consistently took the offensive from start to finish of the war. Chastise was merely one example of that, and one which the Royal Air Force should be justly proud of.