Cartridge recomendations are very opinion based so take what I have to say with a grain of salt.
The shure 97xe is one of my least liked carts. Some say it is a very neutral cart like its canned bigger brothers the V-15 series carts, which I have also heard. But I did not find it to be neutral, just veiled and boring, and at times harsh, and not just harsh in the topend but across the board. I just could not get into this cart at all, and if you look around there are many who share my thoughts.
Now for carts I have liked!
Grado's!!! They are most assuredly my top choice of cartridges. They have their quirks, but when setup properly they can really sing! They have just this amazing midrange that is to die for, and try as I might I find myself always wanting to go back to them. If you listen to any Acoustic or Jazz a Grado is pretty much a must have!
Audio Technica AT95E, this is another great budget cartridge that would match well with the arm on your Pioneer. I would consider this and its Lpgear.com versions my favorite of the Audio Technica line. They are a very good all around cart that has a great topend along with a good midrange and bottomend to boot! It is a very controled cart and is not harsh or over bright like I find the AT 440mla. Another great thing about this cart is if you get the 95E you can upgrade the stylus and get a hyper elliptical or shibatta stylus from Lpgear.com (HE and SA Variants).
Sumiko Pearl, This cart is a bit more than a shure 97xe, but is well worth it! It has a great midrange that reminds me of a Grado (but not as good), and has a wonderful topend once it breaks in. The midbass and lowbass is also very smooth and controlled, not bloated. Its strongest point I have found is electric guitars, they sound so realistic with this cart. The distortion is reproduced very very well, and harmonics are just terrific! The Dark Side of the Moon sounds amazing with this cart, as do other Floyd records.
Hope my thoughts on some of these carts have helped you, Nick