It doesn't work the same for football, because you buy players based on how they fit in a system, rather than on statistical average doing the same thing as the majority of the rest of the team.
Batters are basically always going to be batters, and pitchers will be pitchers - it's only their style that changes (a closing pitcher etc.), but ultimately you have three roles in that sport.
In football, you can have great stats as a striker in one particular team, but those stats will mean absolutely nothing if he goes to another team that don't play the same way. See Benteke at Liverpool right now for details.
So no, it doesn't work. It isn't moneyball to be smart with your money and spend to improve the squad to the system you want to play - that's just called making a smart signing.