Benny
To try to answer your original question...
The "small" does refer to the size, and as Axe said the pistol and rifle primers are the same size. The "magnum" just means that they fire hotter. (Maybe a harder cup too depending on brand) I am certain that your small magnum pistol primers will work with the HS6 powder, meaning they will shoot. How well they shoot is something you would have to try. I cannot speak from experience as like others I have not used anything but small rifle primers in mine. I always use the Remington 7 1/2 just like Ken does. As was mentioned the main reason for the small rifle primer in the 454 is due to the pressure created, and the loads with HS6 are not going to get that high. That Rem 7 1/2 is also a very consistent performer for me, even with lighter loads.
I have not used the HS6 powder, but like you I have read about it and it seems like a good one for what you are intending to do. I applaud you too for wanting to shoot lighter loads to build up your confidence with your gun. Personally I have used Win 231 for lighter loads in Casull cases and have had good luck with them. Another favorite for more "medium" loads is H4227. I have a load with that powder and the Hornady 250 gr XTP that pretty well duplicates the Winchester factory load with that same bullet. It shoots well and is quite mild in the '83. My load shoots 1275 fps from my 7 1/2" gun. In reality that load alone will handle any chores here in Missouri. I have not tried HS6 only because no one around here carries it.
Trust me when I say you definitely can get some good and accurate loads that will be 45 Colt level in your 454 cases. If you do at some point decide to get a new cylinder for your gun, and were it me, I would get a new 454 to replace the one already damaged, and use the damaged one for 45 Colt ammo. Just a thought.
Good luck and enjoy that gun!!!