I don’t think 200 knots is fast enough to create intense heat in the atmosphere. As for travelling through water, AFAIK Russian torpedo’s principle is about to make a cloud of gas around so it is not actually a travelling through water. It is more of missile than torpedo.
Just noticed your reply.
Water is roughly 800 times more dense than sea level air, so I wondered if that would produce 800 times more heat at the same speed.
Of course, water is a much better heat sink than air, so you would have to factor that in, too.
I'm going to wake up my 12th grade physics teacher and ask him to do the math!