The hard aspect of SD video today is the forever shifting technology of delivery and presentation.
In the beginning (roughly the late 1980's, yes HD was around then), SD presented on HD displays with component inputs simply meant it was a tiny image pegged to the zero (0) pixel of the display with no ability of the display to artificially UpRez or convert the image color space. All conversion to HD size, frame rate and color space was manually done with an incredibly expensive hardware standards converter.
Since then it has been a roller coaster ride of ever shifting display technology specifications. This was driven by evolving capture formats with SD standards sometimes accommodated or not, depending on manufacturer.
In short, you can have a TV or display that may or may not have internal means of standards conversion from SD to any number of HD formats accommodated. With the ever changing of interface technology, it often becomes a quest in itself to simply connect a component or composite Video signal to a TV/Monitor.
Accommodation of input of the native SD signal has followed the classic Bell-shaped curve; little to none at first, gradually increasing to maximum within a few years of 2K standardization and now to practically none with adoption of 4K and encroachment of 8K.
The best advice I can give is to capture the original video format in it's native format at the highest possible resolution/bit rate possible in a digital file and then keep that master to make conversions to ever evolving new digital standards and color spaces.
If you don't do this, you will be constantly returning to the master tapes (for as long as they last), re-converting them to whatever flavor of the year/month that is developed and pushed onto the public.
Archive multiple copies your master capture with geographic displacement (i.e., one at home and one on a server outside the home or on an off-site LTO tape) and create a "mezzanine" element from which to generate new copies of the material in whatever converted standard you wish.
Copy once, copy best and convert from there.