Was it the X Craft that caused Tirpitz to flood? As far as I know there was Source (X Craft), Tungsten (carrier aircraft - but I think the largest bomb they had was 2000lb armour piercing), and 617/9 Sqn RAF Lancasters - I am afraid I do not know the codename of the RAF operation.It may perhaps help if the RN's own website was more historically accurate.
Without wishing to denigrate the RN airmen and ships companies involved in any way, Op TUNGSTEN did not sink Tirpitz and didn't even penetrate the ship's armour. However, it did result in significant damage to the superstructure, some flooding from holes beneath the waterline caused by near misses, and significant casualties among those German sailors topside. Further carrier launched attacks were planned or launched in subsequent months but were either cancelled due to weather, proved ineffectual due to German smokescreens, or caused only light damage.
Subsequent Bomber Command raids by Lancasters employed Barnes Wallis' 12 000lb Tallboy. These proved capable of both penetrating the Tirpitz's deck armour and causing serious damage from near misses or - as happened on several occasions - when they scored direct hits but went went right through the ship and detonated under the keel. The ship finally capsized and sank on 12 Nov 44 when 9 and 617 Sqn Lancasters dropped 29 Tallboys. These scored 2 (possibly 3) direct hits on the ship and several near misses; other bombs damaged under-water defences.
Irrespective of who's bombs finally finished her off (and that itself has been the subject of much debate between 9 and 617!), I'd say that the Tirpitz was sunk by the combined efforts of the RN, FAA and RAF. Collectively, they fixed her in Norway before successively damaging and finally sinking her via a combination of surface presence, air superiority, midget submarines and direct air attack, sadly at considerable cost to both sides.
I share your frustration with the website, and the media, in describing naval aircrew as airmen. Mind you, documentaries about US carriers have a nasty habit of describing air group personnel as airmen.