Plot hole: When Charlotte kissed Naveen at the end, she should've turned into a frog as well because she was no longer a princess.
Suggested correction: When ordinary people kiss a frog, they don't transform into anything. (Perhaps they die from infection after a few days.) Charlotte was just an ordinary person. Tiana was chosen. She wished upon the star. Naveen and the consequences of kissing Naveen were a result of Tiana's wish.
Suggested correction: How? She was no longer a princess.
Tiana turned into a frog because she kissed Naveen without being a princess, so Charlotte should have, too.
Tiana broke the talisman that the voodoo man had, thus breaking any more frog-turning spell. I know Mama Odie said that Naveen and Tiana broke the spell when they got married, but Dr. Facilier was still responsible for the spell in the first place, and he died, so there's that.
Plot hole: There is no possible way for the chubby mayor to be able to get in Flint's lab. There is no side entry, and the space other characters use to get in is too tight for him.
Plot hole: When the asteroid first approaches Earth it does so very quickly, but then it takes hours to finally enter the atmosphere and land on Susan.
Plot hole: After the dinosaur kids wrecked the playground, Manny tells Sid, "Whatever they are, take them back" and someone says "What are they?" as well. Later, when Mummy Dinosaur appears, Ellie says, "I thought those guys were extinct!" and one minute later Manny says, "She's a dinosaur!" How could they possibly not see that the kids were dinosaurs if they already knew about dinosaurs in the first place?
Suggested correction: They weren't sure about the baby dinosaurs' species because dinosaurs were thought to be extinct. The mother dinosaur eventually showing up, with her more convincing dinosaur properties of being much larger and menacing-looking, convinces them otherwise.
Plot hole: According to the phone book the name given was "M. Horowitz" but when Mary mails he first letter to him she already knows it's "Max."