The only time I have seen really good shots of the ships is when the one streamer parks outside the major port and just broadcasts all the coming and going. Even when watching single player combat versus pirates(npcs) or the like it never was like the vids I have seen coming from the publisher.
In MMOs, I remember the hard things I did solo, the hard things I organized a team for, and the personal milestones. The zones might be ugly or beautitul. The task might simply be to kite some big demon through a wintry landscape, or it might just be doing something in a new role for the first time. (First time tanking, early raid leading successes.)
In the brief (trial!) time I played EVE, there was a lot I had to learn, and never mastered... but I could see the appeal. While a lot of the success comes down to planning (ship loadout, where you quest/farm/etc), at some visceral level I was still hunting pirates, and trying to solo hard fights that I could not quite beat. It's a rush, even if it doesn't look as cinematic as Homeworld or action movies.
This is likely the same reason people can get amazed or excited about chess or poker. :-)
That said, its likely someone spent some time getting the right angle to take that screenshot.
Up to a few hundred participants can be tense and fast-paced, beyond that it can become a long drawn-out grind.