I hope you mastered your red to prores 444 and not prores 422 or you just deleted a bunch of chroma.
Why would you output your footage to digibeta which is 720×486 not 480 which is dvd output only.
I would definately compare different resizing methods such as AE’s, virtualdub’s bicubic, topaz ,and red giant’s resizer. You can either fit to comp width or fit to comp height depending on if you want black bars(enhanced mode) or letterbox(crop mode)
SD would be rendered out lower field because it’s NTSC. I’d recommend https://wwwss for 3:2 pulldown which is the standard for dvd mastering. Also, hopefully you know about interpreting the red stuff as hdtv(if that’s what you set it up as in red originally conformed) and 32 linear light off. Then master out the output module with color management sdtv so that the color also gets conformed.
https://technicolorsoftware.hostzi.com/