Apologies in advance if any of this offends people's selection in optics.
Open-style red dots have no business being on a precision pistol. There are three things generally wrong with them:
(1) Excessive parallax
(2) Square frame
(3) Poor quality dot for the money
Parallax can't be corrected, worked-around, or overcome. If you're bothering to shoot a decent .22LR, then variations of .2" at 17 yards matter. Open-style dots just don't do that.
The square frame is less of a problem than a "sub-optimal". What you want is a round dot on a circular target inside a circular frame. The human eye is very good at centering that image up. A round dot in a round target inside a rectangular frame is less natural.
Open-style dots also have very poor-quality reticles compared to similar or even less-expensive tube-style dots. Similarly, they often lack sufficient manual brightness controls. Frequently, they might have 11 or 12 brightness levels, but only in automatic mode. That's fine, until you're shooting a well-lit target on a dark background--the sight's light meter will read the dark background, and adjust the brightness too far down.
Get a tube-style 'dot.
On Weight
You're shooting a Model 41, probably one of the most muzzle-heavy target .22s in common use. The weight of the optic isn't going to make a difference one way or the other.
Suitable tube-style 'dots really don't weigh that much, so there's not much of a point trying to either select for a lighter optic, or use an open-style sight.
On Barrel Length
Let's suppose CCI SV had a muzzle velocity of only 1000 feet per second, just so I have to do less math. That translates to 12,000 inches per second, which means that the bullet travels one inch in 1/12,000th of a second.
So moving to a 7" barrel from a 5" barrel means the bullet will be in there 1/6000th of a second longer. A single beat of a hummingbird's wings takes 1/70th of a second.
No, bullet/barrel dwell time doesn't matter. 5" barrel lengths are really popular strictly because that tends to balance really well for most people.
Stuff I Actually Recommend
Sub-$100, I used to push the Bushnell TRS-25. Unfortunately, I think their quality has diminished, and there are a lot of Chinese counterfeits out there. Somehow the price has also dropped from ~$90 to $45-$50, which strongly suggests they've cheaped out the design without changing the name.
Instead, maybe look at the Primary Arms Micro Red Dot MD-RBGII. It goes for $90 and the guys that have it say it doesn't suck.
Over $100, Ultradot-25. You don't need the Matchdot with the fancy reticles.
Over $200, and you're into real money and should have a better idea than that. Personally, I wouldn't go beyond the UD-25 unless I was willing to drop $400-$600, which I really can't justify.