Using the soul to resurrect Rosaria has no relevance in the game, as the player will still be able to offer Pale Tongues to Rosaria's Fingers and have access to all of the services she used to provide, like changing appearance, reallocating attributes and ranking up within the covenant.