"So has my life been a failure?"
First, this isn't a matter for somebody else to decide, right?
And it also isn't something objective. All of these roles depend upon our human myth-making, as Yuval Noah Harari might say.
So it all depends upon one's personal evaluation. Usually during life the value that we attach to things changes, so that what we once held in high regard we may later see as bearing little value. But not always. So the question is whether you still judge yourself by the yardstick of these "important" roles in society and regret not filling one of them. Obviously you couldn't fill all of them and there is possibly some contradiction between them, so that if you'd become the pres. of National Geographic, you might still regret not becoming a cardinal. But maybe you eventually discovered that you all along had a different swadharma and fulfilled it very nicely.

From the age of 16 I was influenced by Lao Tse: his maxims like "One who excels in traveling leaves no wheel tracks", and his council "not to honor men of worth". But that's me. I don't want to lay my trip on you. It's up to you to decide, according to your own measure.