DSC sort of has it right in doing what Babylon 5 did decades earlier: pretty backgrounds are the beef of these visuals, and never mind how unrealistic those are at a conceptual level already.
This is already so many lightyears better than the pieces of wood or plastic we originally got that it's probably way too good already. Set in the 24th century, the series follows the adventures of the crew of the Starfleet-managed space station Deep Space Nine near the planet Bajor, as the Bajorans recover from a decades-long occupation by the imperialistic Cardassians.The station is adjacent to a wormhole connecting Bajor to the distant Gamma Quadrant the wormhole is home to powerful alien beings worshipped by.
Starship are always going to look fake, because they are more detail won't help there. I have no use for quality higher than this. It's not a 'choke point battle' deep inside the system, either: after our heroes break through, it's still about a minute at best possible warp till DS9. It's a different issue that we can rather easily see how the vast cloud of starships is still a pretty compact affair overall, and how it should be utterly trivial to just fly around it. So there shouldn't be all that much action in those shots.
Very few Starfleet vessels have penetrated as deep into the enemy formation as the Defiant has, yet. But the Dominion is supposed to be winning the battle exactly because they are standing still and maintaining iron discipline and not budging an inch. The Starfleet ships are firing and dodging and doing stuff all right, even on the deep background.
