Not exactly - Op Tungsten killed 122 and wounded 346 including the captain. It also undid the 6 months of repair work done since the X-craft attacks. This was a carrier based raid using either 500, 600, or 1600lb bombs.
In another carrier strike (Op Goodwood - actually a series of strikes) the ship was hit again repeatedly and one bomb came to rest in No.4 switch room. Unfortunately it was a dud, but had it gone off it would have wrecked the fire control and switchboard systems, and possibly sunk the ship. Neither of these raids would I in any way describe as “not effective” - they left the Tirpitz as a mission kill for quite some time. The series of attacks left the Tirpitz able to perform no operational deployments from when it was first hit by the X-craft in September 1943 until it was sunk by bomber command in November 1944. I would suggest that this series of raids was actually rather effective and did exactly what they had to.
If the Rodney was so bad, why did it sink the Bismarck with so little difficulty? KGV was there too, but had major problems with it’s triple turrets which weren’t fixed until later in the war and which left Rodney to do most of the damage. Bismarck by contrast did no damage to any of the British heavy ships, with the only damage I’m aware of being what reads like splinter damage to the destroyers Cossack and Zulu.
Not quite sure what you’re on about with “never saw combat against other naval ships during the war” - Rodney was the ship which did most damage to the Bismarck. She also drove the Scharnhorst and Gneisenau in March 1941 (largely because they realised how badly they were outgunned).
It’s clearly a battleship, and the Nelson class (of which Rodney is the other member) were arguably among the better treaty battleships. Remember what this means - they had to conform to the Washington Naval Treaty of 1922. Hence the requirement to weigh only 35,000 tonnes (Bismarck was 10,000 tonnes heavier). And the Baden class may well have been among the better battleships of it’s time, but it’s time was WW1. The Allied navies learnt a lot by the gunnery trials they conducted post-WW1, and this led to a radical revision of armour schemes for new build ships. Bismarck still had a WW1 style armour scheme, and it showed in how easily it was mission killed when KGV and Rodney finally caught up with it. Essentially the armour scheme worked very well at keeping the ship floating, but was awful at keeping it in fighting condition. Even at Denmark Strait the relatively minor damage it recieved was sufficient to prevent it from continuing it’s mission agains the North Atlantic convoys.