I find it does help, I do it in autumn and earlier spring.
I use a garden fork to spike the lawn. Once the fork is in 2/3 of a tine I partly lift the turf. This allows the lawn to be aerated. Walk backwards so that you do not walk on the completed area. I find this very effective.