It's one of the few Pixar movies my kids haven't seen, because I can't watch the beginning without crying and I think that'd bother them way more than anything in the film!
I always tear up, too. But I'm in the 'children should also be exposed to sad things' camp, so I wouldn't mind my hypothetical kids seeing the movie or myself tearing up. It's one of my favourite movies.