For all practical purposes, there's really not much difference in meaning. Either one could be used to announce the appointment of a new manager.
Let's assume we appoint Renee as the manager today. Our Regional Director comes into the office to make the announcement:
Renee is appointed as Manager.
Tomorrow, an absent co-worker comes into work, and asks:
Who was appointed Manager?
(This co-worker uses the past tense, because the appointment happened yesterday). I might reply:
Renee has been appointed has manager.
So, why didn't I say, "Renee was appointed as the manager" instead? Because Renee is still the manager! I could use was – it wouldn't be incorrect – but it might lead to some confusion. I can imagine my co-worker saying:
Was? What do you mean, "was"? Isn't Renee still the manager?
The further the event moves into the past, though, the more natural was will sound, because we're talking about an historical event, rather than a current event. Imagine we fast-forward two years into the future, and I am training a brand-new employee:
Tracy was our manager until two years ago, but then he retired.
Oh, then what happened?
Then Renee was appointed as Manager.
Renee's appointment is no longer a current event, so "has been" doesn't sound right in that context.
This looks a lot like the present perfect continuous tense, except that tense uses a verb that ends with -ing:
Our company president has been appointing a lot of hot shots with very little experience.
I'm don't think your sentence is quite the same thing, though, because of how we'd parse your original sentence. It's not:
Renee (has been) (appointed) (as Manager).
but:
Renee (has) (been appointed) (as Manager).
So, we're really dealing with passive voice here, not the present perfect continuous tense. In active voice, we would say:
The company president has appointed Renee as Manager.
or, the Regional Director might say:
We have appointed Renee as Manager.