If a filmmaker had a 747 engaging in a dogfight with a MIG fighter performing just as the fighter did, the viewer would rightfully say "That's a load of crap!" 747s do not have the handling characteristics of fighters because they are bigger and heavier.
Likewise a 725meter, multi hundred thousands of metric tons heavy cruiser does NOT perform maneuvers like a 4m, 10,000kg fighter. The audience knows instinctively that it's too big and too massive to do so.
Then the audience would be flat out wrong. Vessels in space have no need nor inclination to behave like planes in atmospheric conditions. An aeroplane in atmospheric flight is affected by the physics of the medium through which it is travelling - in fact, the very ability for it to fly
depends on the properties of it. Because of the method of flight in use in a plane, a change in orientation of the plane necessitates a change in velocity. There is resistance to these changes because of the reaction of the physical medium (air) surrounding the plane. The faster it is able to turn, the more manoeuvrable it is said to be.
A spacecraft is in a radically different environment. In fact, to a first approximation, it's not in an environment at all. A spacecraft can spin completely round on its axis without changing velocity at all. 'Front' and 'back' ends are meaningless except to the extent that propulsion can be applied only from certain angles. There is no need for air to flow from the front of the craft to the back to keep it 'up' as there is on an aeroplane. And there is no air resistance to any velocity changes it
does make. The term 'manoeuvrability' does not apply to the two situations interchangeably. You are incorrect to assert that it does.
The 'manoeuvrability' of a spacecraft would result not from the ability to turn but from the ability of the craft to change its velocity. Newton's first law, applied in space, means that it needs to do this by applying a force opposing its present trajectory. And what does it use to do this? Propulsion systems. In Treknology terms, thrusters, impulse and warp engines. And which ship has more powerful engines, a small fighter, or the
Enterprise?