A combination of After Effects, Illustrator, and often Photoshop will give you the tools you need to turn graphics and illustrations into video. Recording an audio track, at least a scratch audio track, and splitting the illustrations and audio up into phrases is a far more efficient workflow than trying to create a single AE comp that lasts for more than about 10 seconds. The best workflow is to create a comp for each sentence, thought, or phrase, make the animations work so they effectively tell the story of that thought or phrase, render the comps with handles (a few extra frames at the head and tail) and then do the final editing of any movie longer than a few seconds in Premiere Pro. That's where you can efficiently fine-tune the narration, sound effects, and music.
I hope this helps. You can expect to spend about 100 hours getting the hang of efficiently working in After Effects. Paid courses like Linkedin Learning are usually a better option than just digging around YouTube for tutorials. To tell the truth, most YouTube tutorials are prepared by enthusiasts, and many of the workflows and explanations leave a lot to be desired. Make sure you vet your trainers.
Most importantly, there is no one-click solution for effective motion graphics. Mobile apps for Instagram and other social media platforms can automate some simple motion graphics, and there are some AI-driven apps on the horizon that look pretty good, but nothing beats understanding the principles outlined in Frank Thomas and Ollie Johnson's book, The Illusion of Life: Disney Animation and a really good eye when you are trying to do the best for your clients and deliver a truly effective product.