That article kind of confuses a few different kinds of sounds. Just because there's a staccato ( https://www.youtube.com/watch?v=L9v-UpM9flY ) sound happening doesn't mean it serves the same function. The loud meme they're talking about is a loud horn meant to overwhelm. The sound at 0:40 in the video is clearly a meant to create suspense: it's an earlier trope in movies and other media: scary staccato strings backed by all sorts of random sybilant string sounds that create a nervous atmosphere (like starting at 2:52 here https://youtu.be/_nVkHXTeiOg?list=PL7F72E09D4C28FECD&t=172 ). My favourite use of these is in the Dead Space soundtrack. Note that in the clip I linked you first get the sybilant strings building nervous tension, then some overwhelming loud bangs, but then at 3:50 you get slower sounds which are not meant to overwhelm, just maintain a scary atmosphere. You get both of those uses of sound in one passage.

BTW, here's what the timbre of the "BRAM" sound is based on for the most part: https://news.ycombinator.com/item?id=32886196