What is the pronoun in the sentence Joe wanted to be a meteorologist?

There is no pronoun in your sentence:

Joe is a noun (the subject).

wanted to be is the verb.

a is the article modifying the object noun.

meteorologist is a noun (the object).