From my view and what I know, aeration is good using the right machine. Using one that minimizes soil compaction of course. So probably talking a walk-behind type that can be rented. But aeration should then be followed up with a soil amendment – top dressing with topsoil, seeding, or some other method to improve the conditioning of the soil. The holes will allow this material to get into the tough ground.