Mentioning the SSD's though, brings me to the other peeve about misuse of naval terminology in SF.
Destroyer is short for "torpedo boat destroyer."
It's another ship type that didn't even exist in the age of sail, and this time neither did its role. The only ships you'd want in your battle line, were your aptly named ships of the line. The need to screen them in any form or shape didn't even exist.
Fast forward to the late 19'th century. One problem that navies faced in the age of the ironclad and later was that as awesome as your big capital ship may be against other such ships, a bunch of cheap torpedo boats could sink it just the same. Enter the idea of a essentially a bigger torpedo boat, this time as an independent ship, fast, agile, with faster firing guns, which could get between your big ships and those pesky torpedo boats and sink them before they can sink your battleship.
Eventually they took over similar roles, like also hunting subs, but that's still the same basic role.
Which brings me to the obvious issue: having a "destroyer" only makes sense if there's anything for it to destroy. Same as you don't have a tank destroyer unless there are tanks. If there is no such thing as torpedo boats, in fact if the only way to get torpedoed is by B-wing or other such bombers, which are best hunted by fighters anyway, it makes very little sense to have a destroyer, does it?
Ironically, one universe where it would make sense to have screening ships is Star Trek, not Star Wars. ST does have smaller and faster ships that can put a few photon torps up your tailpipe. Hell, even later shuttles and runabouts can carry torpedoes, making them a very close equivalent of torpedo boats. Down to being an actual boat, as in something launched off a ship. Also, the equivalent of submarines.
Yet ST seems to miss that opportunity.
But there is a more perverse aspect. Even torpedoes exist and are so devastating because of the obvious vulnerability. Ships can't have half a metre of plating all around, and enemy main guns tend to not cause any damage below the water line, so you don't put much plating there. Ironclads even had exactly none below the water line. Hence a device that can hit you there, is going to cause a big problem.
If you can be hit anywhere, then hitting you with the main guns is going to always be the better option, because they pack a lot more energy and are more accurate.
So exactly what vulnerability would space torpedoes exploit?
The ability to deliver a physical warhead, possibly greater range?
A DEW is limited by the ability of it's carrying vessel to contain it, it's power supply ands it's cooling system.
Missiles have no such problem, and probably far longer ranges.
In fact once effective torpedo analogues are deployed, capital ships are very vulnerable to swarm attacks until countermeasures are developed.
Wrt TBD's, torpedo boats and screening vessels.
Once the self-propelled torpedo, with it's ability to deliver a large, high explosive (shells still relied on LW for their bursting charge) warhead under the waterline was developed it caused the nineteenth century "torpedo boat panic" (as seen in the Spanish-American and Russo-Japanese wars). However the short range, and straight line course, of the torpedo allowed significant countermeasures; rapid firing machine cannon, initially manual and later automatic.
The torpedo boat was able to use one other piece of new technology, the internal combustion engine, which allowed it greater speed than capital ships at the price of light structure and negligible ability to resist shellfire.
Torpedo boats split into three groups: one line continued as a short ranged, fast, offensive platform that was mainly a threat in coastal or narrow waterways, usually deployed in conjunction with artillery, minefields and short launched torpedoes.
Another line of development split off and grew larger, adding larger guns and became the TDB, used to screen larger warships by intercepting torpedo boats at a safe distance. Later these smallish, disposable, warships became the screen against other threats.
The third line merged with the experimental submersibles and became the submersible torpedo boats, relying on stealth rather than speed to approach a target.
Now if space warfare relies on big weapons (laser, particle accelerator, railgun, whatever) you'll need large ships to mount them (and their ancillaries) and protect against them with armour (or anything else).
The Honorverse was at this state in the early 1800sPD; battleships were replaced by dreadnoughts then super-dreadnoughts as beam weapons got more powerful. Missiles were purely ancillary as thermonuclear warheads were fairly ineffectual and missiles easily intercepted.
Battles were close ranged slugfests.
Then the technology changed, under heavily evolutionary pressure. Laser wearheads revitisiled missiles, so pointb defenses got stronger. Missile pods (and eventually the posnought) increased salvo density from dozens to thousands.
In parallel the FAC was developed (a torpedo boat analogue). Initially this was a devastating offensive weapon, but soon interceptors drastically reduced it's effectiveness. Then it was re-invented as a stand-off missile defense screen, to counter the huge missile salvos the capital ships were delivering/facing.
However smaller warships were still around, partially as screen, but often because isolated capital ships were unsuited for many missions: system and commerce raiding, convoy defense, reconnaissance, flag showing, anti-piracy et cetera. They were cheaper and more numerous and therefore used greatly.
On the other hand, take the classic Traveller view of space combat. Small ships are very, very little threat to large ones.
A
Tigress dreadnought is literally a thousand times bigger than the small freighters that players usually have access to. Even with artificial limits on weapon densities the small ship is no threat.
Lower-tech Traveler (around the Interstellar Wars era) had missiles as the king of battle. Nuclear warheads could obliterate anything, so lots of missiles, lots of small craft to launch them, carriers to operate the small craft, interceptors to stop the strike craft outside effective missile range (so more carriers) and screening ships (no bigger than cruisers). Beam weapons are used against missiles, fighters and small craft. Armour is limited.
Looks rather '70s wet navy doesn't it? No subs of course.
Then, around technology level 13 two related developments change the picture utterly (and end the First Imperium); the meson accelerator (and some related improvement in conventional particle accelerators) allow for very powerful, and reasonable long ranged,DEWs. But the nuclear damper nearly eliminated the threat of the nuclear missile, providing at least an order of magnitude of better protection than conventional ECM/interceptor/laser defenses.
The battleship era is born.
Now smaller craft aren't eliminated, there are 11,000 systems in the Third Imperium and a handful of dreadnoughts. Systems need protection from threats other than the Zhodani fleet; pirates, other governments, megacorps, terrorists et cetera so the Imperium also has Patrol Corvettes by the tens of thousand (400 "displacement tons" as against the 500,000 of the
Tigress). Plus a few million Suliemans and X-boats.
Short answer: most naval operations are missions other than war.