I’m doing something similar, myself, as a new UE5 user.
It looks like the post above mine mentioned some good software to dig into, blender being a big one for 3d modeling… I’ve also found a software called cascadeur, for animations. It’s not free though.