I use CCI-400 small rifle and Win-SR in handgun loads often. There is no pressure risk of any sort unless you ignore proper load development techniques. What I mean is... if you were already running some kind of over-book, over max, nutty load that you always run with a small pistol primer and then willy nilly throw a rifle primer in and shoot it -- YES, that would be quite stupid, reckless and dangerous.
Doing proper load work-ups, starting low and building toward a rational goal... then no, a small rifle primer in your revolver or pistol load is ZERO worry of any manner of over pressure.
You might definitely have a problem with ignition, especially with double action fire in a revolver, and perhaps in a striker-fire pistol, but otherwise there is no safety risk when you use proper and safe load development.