I think it involves something called "chemistry." NRE is sometimes called "being in love," "infatuated" or "twitter-pated." There's also an expression, "The honeymoon is over."
I spend 8 years with a guy, and the NRE was long gone. We broke up and spent some time apart, went our own ways, etc...