I USED to want to be. Wanted to be a writer for a while, and also an actress and a singer - waaaaay back in the 1980s. Sang in several bands - not well known ones, and actually did some plays and theatre (AmDram.) Auditioned a number of times for things, and was had singing lessons and acting lessons. Was desperate for fame. Wrote some stuff and sent it to publishers. Had no luck ever.
I never got the fame I wanted. (Like the majority of people who want it!)
I am glad now as I am very happy with my life and would NOT like to be famous. Living in a goldfish bowl, no privacy, always scrutinised, trolls on social media attacking and berating you, possibly getting death threats, never know who your true friends are, not got your own life. Nah mate!
Would be nice to have been a B-list actress (like worked as an actress and always been in work, but not super famous, like a jobbing actress.)
OR as has been said, being a successful writer (under a pseudonym,) or a session singer would be good, as you'd be doing something you love - but wouldn't be recognised.
But still, I'm not that bothered that it never worked out. I have a nice life.
(In my late 50s now.)
Moreover, I don't envy ANY famous person.