The Hood was not destroyed because of "British overconfidence".

The Bismarck escaping into the Atlantic shipping lanes was a threat they could not allow. The Hood and the Prince of Wales were forced to shadow the Bismarck with their radars so that it could be attacked.

No one thought the Hood could beat the Bismarck in a fight - British, German, or otherwise.