Try getting a perfect game and then tell me it's not fun, lol.
Getting a perfect round in any game is fun. Doesn't mean the game itself is though.
Whether it's Call of Duty, League of Legends, World of Tanks, Rocket League, or even Civilization: having a killer game is great, and it's what really seems to make the game fun.
However, if player retention is so poor that nearly 10% of people play 20 rounds, that's a very bad sign for a PVP game. That's not to say you can't have fun, because you are having tons of fun.
Going off the video you posted however, the game play of sitting in the back with a sniper rifle certainly isn't a play style a lot of people find engaging. Aesthetic can't be the only thing to hold a players attention.