Obviously F=MA isn't going to solve the entire problem. The math would not be that complicated. All you'd have to do is figure out how much force a puck at a certain speed would generate, and then how much force is required to move a 40 pound net. I was just saying that to prove a point. Yeah, there's air resistance and friction and it would depend on where the puck hit, but it's all negligible.
I don't really want to entertain an argument in favor of the pyramid trick being real, so I'll just ask, if it was fake, why wouldn't they just edit it so he knocks every puck off one-by-one? Wouldn't that be cooler than him just missing and then knocking the whole thing over with a slapshot?