I just looked up the term. It appears that it started out as the sound a laser makes. Gotta be from Star Trek or some other sci-fi foolishness. If you remember, anytime a laser or phaser fires on TV or movies, it makes that PEW sound. Always amazed me how light makes noise in Hollywood.
But the search also revealed several websites that use the term pew pew. There are air rifle sites and ammo sights, mostly all black rifle oriented. I thought it might be based upon the pew pew sound many of us used as kids when we played Army and our weaponry did little more than go click when you pulled the trigger. Guess that probably contributed as well.
Sorry that your joke was lost on me, Mike. The generation gap exists at many ages. I was getting my haircut the other day and the girl who cuts it is in her 20's. I mentioned wingtips and she gave me the deer in the headlights look. Then I started talking about SNL with the other barber who is much closer to my age. We were sharing remembrances of characters from the John Belushi days and again, she had no idea who any of the characters were. One more. Many years ago, my friend Ray was a pharmacist. But he was really a rock guitarist. Worked parttime at pharmacy and played every weekend with his band. I was the sound man for the band for several years. So Ray is working one night in the pharmacy and there is a cute little girl working the register. The radio was on, and Southern Cross by Crosby, Stills and Nash came on. When it was over, the girl said to Ray, "They are really good. Have they done any other songs?" Ray was speechless.