This is a complex question and I will try to avoid a complex answer. The short answer is no, you don't need SLI but you could benefit from 2 cards under conditions.
SLI and Nvenc/Cuda are 2 different things and don't work together. SLI is meant for rendering only (Cards alternating frames), while Cuda is for computing and nvenc to use the hardware compression engine for videos and so when you enable SLI you cant use both of the cards for computing. Your other problem is that nvenc for consumer cards, due to limitations in its API cant handle more than 2 streams concurrently if I remember well.
Here is where things get weird. Since for encoding, you need only the hardware video compressor, you can get dissimilar cards (like a 2060 and 1650 or a 1070 and 1050) and get almost the same video compression performance as both cards use the same hardware encoder.
To fully utilize such setups you need to run 2 instances of a program like FFmpeg using 2 different videos, one on each card. But you won't accelerate 1 single video to encode at twice a speed.