From the Agilent website:
Compensation range: 6 - 15 pF
I think the 2247A will have approximately 20 pF of input impedance, though I haven't checked. Now the trimmer caps that are responsible for this compensation range are not known for their tight tolerances, so you may get lucky, but you may also not get lucky and then the probe will be unable to compensate to that scope.
A fancier probe can sometimes be nice because of the sharper tip, slimmer body and larger number of compatible accessories. If you wanted accessories to probe SSOP packages, for example, you might be able to find something for an expensive Agilent or Tek probe, but not for a $10 ebay special.