Yeah, the OHP was a generalized type meant more for convoy escort rather than keeping up with carrier battlegroups. CV groups often had dedicated and specialized ships - Tico class cruisers are an example. Spruance was an excellent sub hunter (one of the best, not to mention nice looking).Ca. 1970 the USN had fleet anti-submarine ships were which were designated destroyers (DD), and convoy escorts which were designated ocean escorts (DE). The Perry was the DE of the Spruance DD/ Perry DE high-low pair. She was not designed for fleet work but for convoy defence and was equipped with lower grade sensors and weapons, although some of each was provided (unlike previous DE's).
The USN had a battle force based around CV(N)'s, with each carrier group having a CG(N) for surface action (almost all late WW2 ships with some turrets replaced with missile launchers), a pair of DLG(N)'s (frigate, a large anti-aircraft vessel) and some DD's (specialised anti-submarine vessels). DE's were not part of a carrier group, but rather were assigned to protect convoys, auxiliairies and amphibious landing ships.
In the MSIF, the Aconit fit the role of a Perry, Knox, Brooke or Garcia DE. A general purpose convoy escort, but not one with a high capability in any area, having been built as the low part of a high/low mix.
The "big ship" concept which produced the Suffrens (100 MW for tactical systems, 200 MW for drives) and Richelieus (115 MW for tactical systems, 300 MW for drives) envisioned ships powerful enough to operate independently or as the core of a TF. These fulfil the roles of CG and CV. In the middle, the capable "normal" ship is probably based around a 150 MW fusion plant* and uses either 75 or 100 MW for the drive, leaving 75 or 50 MW for tactical systems. One of the oldest types is in SotFA - the Ypres class had a 150 MW fusion plant, 100 MW for drives and 50 MW for tactical systems, and is called a frigate. She'd be the equivalent to a DLGN frigate.
The "destroyers" are likely the 75/75 MW versions, a bit slower but more heavily gunned.
We don't have need of different anti-air, anti-sub etc. ships, but I've assumed things are moving towards more drone and missiles, and especially fighter carriers are starting to appear, and they are extremely powerful units that only the two most powerful nations, France and Britain, have.
* Fusion reactors have a minimum size of 150 MW (ca. 500 dTons) this creates a minimum size for fusion vessels.
USN made changes, some due to tech and some due to budgets, on their fleet. They could no longer afford the post-WW2 fleets. And with tech changes some platforms could do more with fewer hulls (though the current fleet is a bit too small to cover everything - the Constellation FF will hopefully bring the OHP concept back into vogue - you don't need Aegis-equipped destroyers for doing the more mundane needs of having hulls present around the world).
I don't have any 2300 stuff anymore (do have all the Challenge magazines in their OG format - paper!). And when I played we never really got into the naval portion, let alone the design aspects.