You are the only one who can answer whether a SA revolver works for CCW. If you are fast and accurate, if you can "run the gun" and still be safe with it, then I'd say the answer is yes. To hone your skills, you could join a CAS group and learn to shoot a SA revolver under the stress of competition.
There are few situations that 5 or 6 rounds of .45 Colt, .44 Special (in a .44 Mag.), or .44-40 can't solve. I would suggest practicing the reload, and to consider the carry of a small, light backup like an Airweight Smith or a Ruger LCR as a backup to the SA.
I also suggest reloading. It's about the only way to be able to shoot the big bores in quantity without going broke. I buy my .45 Colt brass direct from Starline. The only .45 Colt factory ammo I've ever bought was for defense, but all my practice and plinking ammo is handloaded. The straight-cased big bores (not the .44-40) are very easy to reload, and an effective .44 Special or .45 Colt load is surprisingly mild to shoot. With proper bullets and loads, your SA could also serve as a hunting gun. The .44-40 isn't real hard to load, but you have to be gentle with the bottlenecked cases. Heck, in the Model 92 Winchester, the .44-40 has probably accounted for hundreds of thousands of deer.
In answer to whether anyone carries a SA revolver...I did when that was what I had, and I would carry one again if it was the best choice available, but now I carry either a DA revolver or a DAO auto. I feel safer with the DA trigger as insurance against an accidental discharge when I'm charged with adrenaline. I'm also faster with a DA revolver.
The one time I thought I was going to have to shoot another human being, I had a Taurus .38 Spl. DA-only revolver with a rather heavy trigger. I was waiting in ambush as two men attempted to kick in my front door, in a random home invasion attempt. I was aiming at the spot that they would pass through if they got the door open (they gave up before the door did). My fine motor control was completely gone, making it hard to dial 9-1-1 with the phone in my left hand. I felt confident with the DA, as it would fire only when I deliberately squeezed the trigger. With a SA, I would have waited to cock the hammer until I was pointed at the target and had made the decision to shoot.
Stay safe,
Dirty Bob