Actually she did make a couple of brief forays out into the North Sea if I remember my history right...? But mostly he main affect was to be a huge drain on german resources and a sitting duck or Allied bombers.? Warships aint much good if they are in port under repairs all the time
She didn't make any forays but not in the North Atlantic (she was not part of the channel dash - that was the Bismarck and the Prinz Eugen), but she was based in norway so her targets were going to be Russian convoys. however I doubt she went near any convoys, the German navy did not wish to risk their last capital ship, especially when a considerable British Fleet was stationed nearby (at Scapa flow).
There was another major German surface vessel (Scharnhorst?) also stationed in Norway that would have supported the mighty Tirpitz against the Russian convoys, however she was sunk be superior British forces and U-boats and the Luftwaffe proved to be a more efficient alternative. So, despite her firepower the Tirpitz pretty much remained in port until she was sunk late in the war (I think in 1944). Like the Yamato - it was a sad end to a powerful warship that never saw its full potential.