So this is a weird first post but after reading through the entire thread, I felt compelled to defend one of the "lowbrow" jokes.
Namely, the dog licking itself gag. Yes, the dog licking its crotch in itself is just kind of vulgar. But I don't think that's really the joke.
The joke is making fun of the trope of all communication being in video on TNG-era Trek. Every time you contact someone, they're in a perfectly framed shot, and if anything is going on in the background, it's some convenient setup to demonstrate the setting.
Well, that's not really what it would be like, would it? Things like what we saw, i.e. something mundane and inappropriate, would pop up in the background quite often. Someone's kid runs in, a dog licks itself, etc. It would be rather weird if every scientist and civilian was always perfectly composited as if a crew had set the shot up for a cable news talking head segment.
Anyway, that's what I got from that scene, and that's what I found amusing about it, not "ha, look at the dog lick it's crotch!".