I would be thoroughly shocked to find that this product was anything more than mass loaded vinyl. Which does work well as a way to add mass and, to a lesser degree, isolation to any standard three pillar approach to sound proofing (the three pillars being mass, isolation and air tightness). So, yes, I have a layer of the 2lb per square foot version of that product in my studio walls.
That said, it is just one product that provides mostly one pillar: mass. So, I wouldn't expect that I could apply one layer of this between studs and sheet rock and have all of my problems solved. Add this to an already complex build with sheet rock, green glue and hat channels and then you'll have something effective. So, this is a great product once you've cross the cost/return point of about $5,000 per 100 square feet of studio space. Up tot that point, I would stick with piling on less expensive materials such as sheet rock, green glue and channels.
BTW, it is relatively simple to stop the medium to high frequencies of a running jack hammer with air tightness and even a meager amount of mass, so this demo isn't really as impressive as it might seem. I would have expected the same or even better results from a box made from an eight dollar panel of sheet rock. Stopping your bass or floor tom from getting through is a whole other universe of problems.
Bottom line: there is no "one product that does it all." Well, except for lead. In fact, you will even need to buy some expensive 2" lead tape to close the seams of this product in order to use it effectively. Add the up the costs on that some time and let us know the feeling that you get in the testicle region.