The moment asymptotics of super-Brownian motions