We already have new torpedo explosions in the game
They have much more details included, like those that you described in your post. We will soon see, if the beta testers will like them. We were loosely basing on the same video that you suggested as reference.
Bow splashes and depth charge explosions mentioned by @W_clear are still left untouched though. I hope to upgrade them soon and any advice is most welcome.