JohnD - what is "The Titan"?
It is a cheap SDS drill with a rota stop, my SDS does not have a rota stop so will not hammer in an earth rod.
No. Don’t waste your money. You will need an Earth Loop Tester. They aren’t “cheap”
Even if you had one, how would you test it? What impedance would you expect to be within the acceptable range? What would you do if it is out of limits.
Do the EICR. Then act on the findings.
I find it is easy to spend someone else's money. But once we suggest methods costing a lot of money, the chance is nothing will get done. My problem is with an EICR we are relying on someone doing the job correctly, and in the past there have been too many drive past EICR been reported.
The same applies with other reports, home buyers reports, and Energy Performance Certificate, my old house had an Energy Performance Certificate but no one even visited and neither did we pay anyone. I did a hunt for next door but one, and found I had one.
So we have a pacific question, about an earth rod, and we know it takes seconds to test the earth system with an earth loop impedance tester

one simply plugs in, turns the dial and press the button and one has a reading as to the earth loop impedance, but the meter is expensive, so not really a DIY job, I did look at hiring, the problem is calibration which needs re-doing after each hire, so even to hire looking at £60.
The net result is cheaper to get an electrician to test a random socket to hiring the equipment. And as I said to do a proper test on an earth rod you should be using test probes, which often simply can't be done as you can't get the distance away from the rod under test to put in the probes.
He has already said he can't get an electrician to test the earth rod, so a little pointless talking about getting one.
So nitty gritty, the reason we use an expensive tester is we are looking for a figure to write down, we want to write 1.38 Ω or less down on the minor works or installation certificate, and to get that sort of reading it needs a meter, and even the meter shown does not have enough decimal places to comply with our needs.
But to see if below the limit which BS7671 says is the maximum as above that limit it may be unstable, a plug in socket tester (with loop) will show one has a good enough earth.
I will admit some can be misleading, as often they assume one has a DNO earth system, and have a 1.7 - 1.9 Ω pass point, but most have a series of green and red LEDs to show reading of up to 500 Ω which is clearly a fail, but we expect a single earth rod to be around 60 Ω so they are good enough to see if within that range.
Where the DIY bit becomes hard, is where like my own house, we have multiple earthing systems, my home is TN-C-S and TN-S it depends on if the grid supply has failed or not, and my earth rod is only there in case the grid fails. So to test means disconnecting and reconnecting cables and wires. This does need a professional to do the work. However, with a simple TT installation using a plug in socket tester with loop will show if you have an earth. It will not test the rod, but in real terms that does not matter, if the earth is due to water pipes, earth rod, gas pipes or metal in the foundations, if it is good enough to trip the RCD then you are safe. And a plug in tester will tell you that.