I'm one of the creative directors at Vidico (https://vidico.com/) — if you don't have animation skills in-house, the main area we see founders/marketers contributing is in the scripting and messaging of the video. I'd use an agency for the rest.

The reason being is that creating a video is super time consuming.

Not only that, but if you spend the time, it won't always result in a very unique or differentiated video.

If you don't opt for 2D animation and you're just getting started, the quickest way to get a good result is to use Loom to record your product with a solid 60-sec pitch of you speaking to camera in good lighting.

It's this kind of video production that can be a huge time-saver for any kind of startups who are pre-seed.