Core aeration is the only thing that relieves compaction without wrecking the lawn to get there. Tillage decompacts soil and kills the grass doing it. A full renovation does the same. So when a lawn is genuinely compacted, cores are the right tool, and I am not going to repeat the line going around that aeration does nothing for compaction. That is wrong in the other direction.
There are two honest qualifiers. The first is density. Research counts cultivation in cores per square foot, not in passes, and Kansas State's turf program puts effective cultivation at 15 to 30 cores per square foot. One pass with a commercial spoon aerator delivers roughly half of that or less, which is why a single trip around the yard measures out to nothing at all. Two or three passes in the same visit is what moves the number. The frequency work agrees: going from one cultivation event a year to three dropped soil bulk density 5 to 9 percent and surface hardness 5 to 19 percent. Real, modest, and it takes repetition. The core-density numbers are laid out here if you want the studies.
The second qualifier is our dirt. Maury County clay closes the holes in weeks. It swells, settles, and takes its old shape back, the same clay under Columbia and Spring Hill lawns.
Then there is the part nobody selling aeration mentions: genuinely destructive compaction is uncommon in a lawn. Root channels, earthworms and soil biology, and the freeze and thaw cycling a Zone 6b to 7a winter delivers all work against it year round. Real compaction is something people cause by putting the same weight on the same footprint over and over. Most of what gets called compacted soil out here is heavy clay behaving exactly like heavy clay.