This was was sometimes called the "Starcraft under the sea", but that's a pretty unfair comparison. While it does bear some similarities to Starcraft, it's also very different and offers a unique experience. There's a learning curve to the game has the UI is laid out differently, there's lots of units with specific roles, there's multiple different resources to manage, there's a depth system, and the campaign is actually quite challenging right from the outset. There are three factions, some really nice looking CGI cinematics, pseudo-3D visuals that still hold up (especially if you increase the resolution) and nice features such as not having a unit selection limit, which believe it or not was the exception back then rather than the rule. You even have the ability to trade one resource type for another if you find yourself with an excess of one but not enough of another.
You may need to tweak a few settings to get it running exactly to your liking in Windows 10 but it otherwise runs very well. It's not without a few flaws (for example all of the units in each faction have the same voice clips, making them difficult to differentiate), but the positives substantially outweigh the negatives.
I go more in depth with Submarine Titans as part of my Windows 95/98 Hidden Gem video here: https://youtu.be/QEBPbKODlVg