I'm probably in the minority, but I actually prefer for there to be a sound effect when you kick the ball. While it's true that in real life, when you're watching a football match on television, or as a spectator at the match, you can't hear the sound of the ball being kicked, it's also true that you can't take control of any player on your favorite team at any time, and make them do what you want.
I find it to be more immersive when I can hear the ball being kicked. And hearing that thud when I take a powerful shot that results in a goal makes it that much more satisfying.
As for the actual kicking sound effect, it could probably stand to be a little better than what's in the demo, but I'm not bothered by it.