I've only been to Moncton once before, but my dad used to live in Saint John, NB. Just be happy that it's not Saint John you're moving to (it smells bad from the mill).
New Brunswick has beautiful places to explore, beaches with the warmest waters north of Virginia, the highest tides in the world, and friendly people.
Moncton specifically has a good waterslide park and an indoor amusement park.
Just be prepared to deal with very snowy winters, a smaller-town life, and a bilingual population.
I'm sure you'll enjoy your time there.