It is not just the weight of the gun, but the design of the grip frame and whatever grips/stocks/adapters one uses, and, how the whole package fits the hand.
An example, for my hands, is the pre-Hogue-grip-era Ruger GP100 factory grips. On the same weapon, the rounded version is painful to use, while the squared version is one of the most comfortable grips I have used on any powerful revolver. (All GP100 revolvers have the same tiny grip frame.)
Then, there is how one holds the weapon. Generally, it is better to hold quite high, on the back surface of the grip. The barrel, when viewed from above, should be in line with one’s forearm bones. If not, well, not only will shooting be more painful than it should be, but cumulative long-term damage can can show itself later in life. I learned this latter part, the hard way, regarding big-bore N-Frames. (.22 LR is now my right hand’s only friend, among handgun cartridges.)