I think
Rosie is an adorable nickname, but you're right it's not substantial enough to stand on its own. It's too cutesy for that. I like it as a nickname for
Rose,
Rosemary and
Rosaline. I think it works better as a nickname for those names than double names like
Mary Rose or
Lily Rose, although I quite like
Mary Rose.