Pie-eyed (de olhos arregalados) [the second meaning]

The first one is "drunk", "pissed" (both drunk or fed up, etc)

Now: To stare wide-eyed in awe. (de olhos arregalados de surpresa ou admiraçao/olhos arregalados de
Pasmo).
Ref. idioms.thefreedictionary

The kids were totally pie-eyed when they saw the pony in our backyard. Then, Claire declared it her "best birthday ever."

And a 'third' meaning, as in "pie-eyed optmism":
"Pie-eyed optimism" describes a naive or foolishly excessive optimism, similar to the state of being "pie-eyed" (intoxicated or wide-eyed with surprise). It refers to a kind of optimism that lacks realism, potentially ignoring facts or dangers, and may be driven by an unrealistic belief that everything will work out perfectly. Source:Google

This can seem like pie-eyed optimism to some, but its often really true. Many people are surprised to find they can actually afford to purchase a home.

Ref. theguardian
Ten years ago, I plunged into parenthood in a state of pie-eyed optimism. Thinking that my newborn son was a blank slate, I foolishly thought that I would be able to influence his personality and determine his character. I now realise that I was completely delusional.

Parenthood - maternidade e paternidade, genitorialidade (o estado de ser pai ou mãe).

Parenthood - fatherhood and/or motherhood, so it's a more generic way, not solely focusing on the role of the father or mother.