The Tirpitz was damaged by the mini-sub raid. But she was sunk by bombers dropping unguided 10,000 pounder bombs. She was hit a couple of times and rolled over.
You can go on Google Earth, or other mapping services, and see the site of the Tirpitz's sinking. The ship has been scrapped, but huge craters can still be seen at the nearby shoreline, from Tallboy bombs that missed.