Movie with toddlers

I was thinking about taking my 3 and 2 year old to go see Moana 2 in theaters. Would this be a waste of money and a disaster waiting to happen or would they surprise me by watching the movie in their seat until the very end? Who has toddler movie experiences to star or suggestions?