There's a restaurant across the street from where I live and they have New Year's Eve parties. Twice now, the owner has called the police when I shoot off flares because I scare his drunk patrons (oh boo hoo). If the police catch me in the act I go to jail (no shooting in the city limits). When the cops drive by, I've already put the gun away and they just scratch their heads. These milk cans would really rattle their wine coolers but rather bulky to hide quickly.
The rounds are phosphorous and might be a little accurate with practice say 50 feet or less. I've only fired it into the air. I like the idea of a carbide cannon but they're expensive. The one shown on your video is nothing short of radical and must've cost thousands (people with a lot of extra money and time). The army grenade launcher would be fun to shoot. The flares shown here are $7 to $10 each depending where I order from. Over the holidays I found another source for $5 each.
I know about the hand-thrown type but didn't know they came in pistol form...I'll check cause I like noise. I have a 'sleeve' insert that sizes this pistol to a 12 gauge making it quite optional (all kinds of goody rounds). The shells shown here burst at 150 ft. with 3 to 5 red balls. Quite brite they are.