A quick search found this example 18 second video generated on 3090: https://old.reddit.com/r/StableDiffusion/comments/1kp5jb8/da...

I am pretty sure what you want is doable on a 5090 with some effort but it will not be just a text prompt to video. More like input key frames as images and interpolate video between them.