Capital-ship names suit submarines - except perhaps Warspite

Should grand historic names be assigned to future large destroyers or other capital ships?

Yes for capital-status ships, but Warspite is an awkward name for an SSBN because the name is associated with repeatedly finding combat.

Aircraft carriers, ballistic-missile submarines, and arguably LHDs are the capital ships of their era. Historic names suit ships of that status, although Warspite has too strong a habit of finding action for a deterrent submarine intended to avoid it. A carrier or Type 83 destroyer might be a more appropriate bearer of the name. The joke rests on a serious naming tension between prestige and the SSBN's mission of remaining hidden.