DV is an editing codec, while is has smaller color space and more compression then ProRes, if your video is that format (or similar) it is fine to work with. If you are doing heavy graphics then ProRes would be better.
I’m sure if you googled “video codec” you can find the info you are wanting. But this is not a new thing. DV, DVCPro50 and DVCProHD are the only format where whats on tape and whats digitized is the same thing. Every other tape format you have to choose the right codec to digitize to.
Oh short answer, whenever possible choose ProRes.