In capacitive moisture measurement, you have a capacitor with some amount of water in the dielectric material. Since water has a very high relative permittivity, the capacitance of electrodes put in soil is dominated by water concentration. The good news is: This is true for a frequency range from very low (Hz) to at least 1 GHz. So, nothing to worry about, moisture will in principle be detectable at any practical frequency. In consequence, you can choose your measurement frequency entirely from circuit considerations.
Depending on the geometry of your sensing capacitor, capacitance will perhaps be quite low. Hence, choosing a high frequency f has the advantage of a large voltage drop U across the capacitor C at a given measurement current I: ω = 2πf, Z = 1/(ωC), U = IZ.
OTOH, measurement at high frequencies is generally more difficult, especially if long wires are involved and you have to take parasitics into account. This is less of a problem if the measurement circuit sits close (mm) to the capacitor.
Not knowing the circuit you have in mind, the distance between circuit and capacitor, the electrode geometry, and the actual application, I would say that a freqency of several hundred kHz is not a bad choice. If you want a more precise recommendation, its necessary that you provide more detail. Do you already have capacitor and circuit, or do you want to design them?