Can be seen in this video within the first 10 seconds
To both of these:
Yes, you can have these animations in an iframe, but you’ll have to either write CSS or hire someone who knows how to write CSS to make them.
Yes as David says, you can’t do that text drop effect without using a third party.
I think you can get an app for something similar to that through Wix apps, however that would be a cost to you each month and when you can do it through code for free if you know somebody or you can find it online, then it makes sense not to use an app.
You can have a search online yourself and start learning it yourself if you felt brave enough…
https://thoughtbot.com/blog/css-animation-for-beginners
https://javascript.info/css-animations
https://marksheet.io/css-animations.html
Or you can look at doing something yourself that is allowed within the confines of the Wix Editor and a bit of code already.
https://www.wix.com/corvid/reference/$w.EffectOptions.html
or just upload an animated gif file (if the text itself is static).