The truth about all flow and especially turbulence is that it is not hard to make it look convincing to the human eye. Capturing the motion on various length scales and presenting it in a plausible way is not all that computationally intensive (the algorithms to make them can still of course be challenging). Making simulations that are numerically correct, however, is incredibly computational intensive (in addition to being algorithmically complex). This is why CFD is still run on massive clusters for transient simulations. There is also a whole field in itself for "sub-grid" turbulence models that allow for the spatial resolution of a simulation to remain coarser than the Kolmogorov microscales (https://en.wikipedia.org/wiki/Kolmogorov_microscales). (As a side note, Kolmogorov was a true polymath/genius in areas outside information theory and complexity theory.) Cutting edge basic research on turbulence will perform calculations at such scales (direct numerical simulation). Suffice it to say, most graphics work does not waste too many cycles on physical accuracy. Hard to know for sure, but since the video has words "cinema" and "rendering" in the description as opposed to "simulation", it is probably just realistic enough to pass muster in terms of human perception. Also accurately simulating the formation of foam requires a two-phase simulation of both gas and liquid as well as considering cohesive forces.