I think it's safe to say that, between the primary sense of "rocky" being "made of rock" and elementary common sense, nobody does ;-).

People aren't going to think Rocky Linux is unstable for the same reasons why they don't think Apple computers rot if you leave them in the sun. Also, if a product called Red Hat Enterprise Linux was successful despite the name, I'm guessing it can't be that much of an obstacle for Rocky, either.