I like it. I don't see it getting popular in the US any time soon. I think I'd prefer
Mary as a nickname because it's not as common these days as
Rose and
Rosie. Although neither of those are very popular in the US anyway. Except for
Rose as a mn. Gah.
Mary Rose is nice too, but I prefer
Rosemary.