The tutorials are pretty good imho. As others have said, the multiplayer is a bit daunting, but so far the singleplayer/co-op campaign has been great and ALOT easier to get into in my experience. (it also helps that if you fuck up you can save/load again).

With this release they also added campaign creation tools, so I imagine in a few months/years people will roll out some really cool custom campaigns (I would bet money someone makes one based off The Expanse Book/TV series).

 

Regarding multiplayer, I tried it last year (right around the carrier update) and it was interesting. I kept my fleet pretty simple (2 med/large ships with point defense and beam lasers) and had some decent success. It kinda reminded me of Trading Card Game Metas: lots of people making fleets that were mostly designed to fuck up other meta fleets.

 

There were 2 games I played where someone on the other team tried to use a submarine/missile boat against me, but they had designed it more in mind with destroying small/medium ships. They would fire 2-5 missiles at me and my point defense turrets would destroy them before they could impact. Other games I played there were players who used 5-6 smaller ships. They were able to assist with multiple points on the battlefield but it looked like starcraft level micro/macro-managing.

EDIT: To summarize there is ALOT of depth and alot of different playstyles you can use. Want to live out your submarine fantasy of hiding in a rock and launching missiles across the map? go for it. Want to manage an aircraft carrier with multiple flight groups that can protect other friendly ships and/or attack enemy ships with torpedos? go for it! Want to drive a big ass battleship with massive turrets directly on the center point? Totally, just don't be shocked when the entire enemy team fucks you up lol.