The 41, as with target .22s generally, is intended to be used with standard velocity ammunition. I've heard that S&W specifically "designed" the 41 to be used with CCI SV, but I can't confirm that and it's not entirely clear to me how (or why it should be necessary) to design a gun around a single brand/type of ammo. I do think that most shooters find the CCI SV to work pretty well, regardless of whether the gun was actually designed for it.
I shot a 41 in Bullseye competition for many years before switching to one of the high-end European target guns. I still compete using the 41 occasionally, and several of the shooters on my pistol team use them. From seeing dozens of 41s over the years, my observation is that each is a law unto itself - some are exceedingly picky, both in terms of function and accuracy, about ammo while others, including mine thankfully, digest pretty much anything.
The advice from earlier posters is spot on - stick with SV ammo and buy a box of as many brands as you can (not as simple these days as it once was), then test them in your gun for function and accuracy and hope that you can find more of what the gun likes. And especially hope that your 41 isn't exceedingly fond of Eley Tenex, unless you're independently wealthy.