My experience would also be that it is rare, and I don't know anyone with it. There is the golfer Justin Rose. But Wiki seems to think it is quite common - 69th most common UK surname!
https://en.wikipedia.org/wiki/Rose_(surname)
As a middle name, it is quite common, I think, because it was a popular first name some time last century, and lots of girls have a middle name in memory of a grandmother, or other relative. My niece has it as a middle name for that reason.
Somewhat common, but not at all evenly distributed. In Kent or Lancashire, it doesn't even make the top 800.