2 dams, a couple of damaged subpens and an enemy battleship sunk does not seem to me a good payoff for over ten thousend bombers lost with 55 000 crew onboard, an effort that amounted 40% of the British war spendings according to AJP Taylor.
Hmm, Tirpitz...Flown by the best RAF bomber pilots, perfectly clear weather, no enemy fighters etc...
.. and out of the 60+ large bombs dropped, I think 1 or two hit a stationary, 250 m long, 36 meter wide target.