Yes, it does. The gap you're leaving above the shoulder, especially at the height of an NHL goalie, is miniscule. If they can hit that spot, they were hitting it in VH or even just at a full stance regardless. For any other short side goal that goes in, it doesn't matter whether you're RVH, VH, or standing up. If you're not against your post, you're not against your post.
There's two nonsense issues with RVH and a couple legitimate ones. First, you get non-goalies (or old-school goalies) on TV blaming goals on RVH. Second, you get those same people on TV saying stupid things like "he went down early" as if he was supposed to wait until the shot was on its way to drop into RVH. As for legit issues, there are certainly goalies who overuse it. Also some guys fail to seal the post with it.
The other issue with using VH or standing up is that your ability to cover a puck is basically zero. At that point you're pretty much depending on somebody to clear it. Imagine a shot coming in and hitting you while you're in either of those positions, and the amount of movement and re-positioning it would take to cover the rebound in the crease. Now consider how quickly you can move from RVH to cover since you're basically into a standard butterfly once you move away from the post.
To your last point, goalies aren't ever going to concern themselves with a save selection based on how deflating a goal might be if it doesn't work out. They're going to make their save selection based on what gives them the best chance to stop the puck - period.