I starred in every high school play
blew every drama teacher away
graduated first in my class at Juilliard
took every acting workshop I could
and I dreamed of Hollywood
while I read my Uta Hagen and studied the Bard
In my understanding, the unhappiness expressed by the singer comes from failing to achieve his lifelong dream; that's why I posted the stretch above on "How to let go of a lifelong dream".
I find that near-final couplet - Always said I'd be famous / I guess that I lied - to pack an extraordinary amount of tragic punch for 11 words. Sometimes it can cost a lot to admit something, even something that everyone knows.
That said, I saw an interview with Weird Al in which he was asked about reactions to the song, and said that theme park guides tended to like it. After all, the song depicts them as responsible people who pay the rent. The people who really hate the song (according to the interview) are actors.