tl;dr: water droplets scatter the sound keeping it more localized, and also absorb some of it, while some is also absorbed in all the other surfaces the sound strikes. There's no where near enough power to boil this much water.
Sound in the air at these (audio and sub-sonic) frequencies pretty much always ends up as mostly heat.
Ultrasonic sound can be use do work on the surface tension of water (ultrasonic atomizers, humidifiers, etc) but when that's used in a practical way the wavelength is usually millimeters and the corresponding frequency in MHz so the sound pressure can be focused to a small, high-intensity area for more efficient disruption of the surface into droplets.
But that's not what's going to happen here.
For audible and sub-sonic rocket launch sound, the deep sub-wavelength but high density droplet dispersion will diffusely scatter the sound waves, decreasing their mean free path and therefore increase the time for the sound energy to be mechanically absorbed, both by the droplets and by any other local surfaces the sound reaches.
How much energy and therefore heat are we talking about here?
Until dB levels with their corresponding distances and measurement conditions can be found, here is a walkthrough of the conversion process and are some rough estimates:
So far I found a sound level of about 160 dB at 125 feet in this answer and 180 dB in the payload bay of the Space Shuttle in this answer but these are not helpful; the first one is with the sound suppression in place, and the second is in a confined, closed space.
But I'll show how to do the estimating calculation here in hopes we can get better numbers.
In this excellent answer to my question How much power and energy is (actually) in a 230 dB “click” from a whale? the equation was derived as follows:
Intensity (or specifically sound intensity) of a linear sound wave is related to sound pressure, $P$, through:
$$
I = \frac{ P^{2} }{ \rho_{o} \ C_{s} }
$$
where $\rho_{o}$ is the mass density and $C_{s}$ is the speed of sound in the medium. One can look up the properties of water to find that $\rho_{o}$ ~ 999.972 kg/m3 and $C_{s}$ ~ 1484 m/s. We can also look up the reference pressure level for water (or at NOAA) finding $P_{H2O}$ ~ 1 $\mu$Pa (compared to $P_{air}$ ~ 10 $\mu$Pa) at 1 meter from source. This corresponds to a reference intensity of $I_{o} \sim 6.74 \times 10^{-19}$ W/m2.
$$ I = I_{o} \ 10^{L/10} $$
where $I$ is intensity (in W/m2) and $L$ is intensity (in dB).
So for example, 160 dB at 125 feet (38 meters) would be 7 mW/m^2 or about 15 Watts integrated over one hemisphere.
The largest number I saw was in this answer
The Saturn V predated this suppression system. Early engine tests reached as high as 211 decibels.
If we were to try to use the same 38 meters distance, 50 dB is 10^5 means 1.5 megaWatts, and that could potentially boil a few kilograms of water per second if it were concentrated on a few kilograms. But that's not the case, the sound is dispersed over many tons per second of water and the ground and other surfaces.
There are more dB values in this answer but they don't have a clear geometry description.
Nonetheless:
No, no water was harmed boiled in the making of this film orbit.