The mounted gun sequence you're talking about is actually in CoD:MW2, not CoD4. Moreover, it's vaguely similar to some of the Marines missions in CoD4, perhaps, but it has absolutely nothing like the SAS missions, which are what made CoD4 so memorable in the first place.
So yeah, wrong game...