I'm not sure this is the best title. "What happens when you wiggle a hose at a frequency close to a camera's frame rate and then film the water coming out of it" might be better.
At the most basic level, this is just the game you used to play with a hose when you were a kid by waving the end and producing ribbons of water in the air. The video just added a camera trick to photograph the ribbon in the same place during each oscillation appearing to freeze it in place.
Initially I thought this was going to be much cooler, actually using the speaker to move the air through which the water was travelling to produce an effect. I was hoping for an awesome standing wave demo or something.