An EFHW, like most high-up horizontal dipole-type antennas, doesn't really need a ground-in-the-earth to work properly. The whole antenna is up in the sky, the currents are horizontal. It has no need to be connected to the ground, which is not part of the antenna and too far away to matter (to the currents in the wires... of course the ground also interacts with the fields).
A vertical antenna needs a good ground as its counterpoise. Ideally this would be >100 >half-wavelength wires just above the ground, but a couple of wires laid out in a few directions will also work. A ground rod or two might also work, depending on the soil conductivity, but as with mains electricity, for ground rods to work properly you need some length in contact with the ground. A 6 inch ground rod is not going to do anything at RF. 3 x 8 feet rods would be better. Still not as good as ground radials.
(Fun comment - on fairly dry ground, I've found that HF wire / dipole ntennas work quite well just lying on the ground. Certainly more lossy than at a proper elevation, but at 40 m a proper elevation is hard to achieve anyway).
In my limited EFHW experience, the type of counterpoise affected the antenna mostly outside its resonant bands. The antenna response was much better behaved (nice smooth high SWR) when it had a big counterpoise. With just the coax and shack as counterpoise, or with just 2 m of cable and a battery powered VNA, the SWR had additional dips in various places, all unstable and sensitive to me touching the coax.
At the resonant points (7, 14, 21, 28 MHz in this case) the performance was about the same with and without the bigger counterpoise.
You should still ground your antenna and shack for lightning protection, complying to your local electrical code. And depending on the way that the cable runs, it may help to ground it along the way to prevent any leftover RF from getting back to the shack and into your microphone cable.