I'm going to jump in here with the end all arguement which no one can overcome.

The EXCALIBUR-class is a 25th century version of a CONSTITUTION-class, which means all design flaw, limited ability, cannot keep up with the times non-sense goes out the window.

And yet, the Excalibur-class is pulverized by the antiquated Intrepid-class and oh yes my personal favorite example of "we must keep it cannon": the EXCELSIOR-class.

No one is saying the lower tiered vessels should be able to solo the upper tiers. But the lower tiers DO need a significant upgrade and there should be perks and drawbacks to both.

The perks of the lower tiers being maneuverabiltity and a low sensor profile making them harder to hit, but the smaller ships are limited in their weapon loadouts making them pack less of a punch. Bigger ships on the other hand, can dish out TONS of punishment, but maneuver like slugs, but then they can take the abuse.

In this regard Eve Online hit it square on the head and the devs for STO really need to take notice.