I recently went through the same process as you. Tidal is either CD quality (16/44) or MQA, which decodes to a few different sample rates. On Tidal I’ve seen up to 24/192 MQA files.
The upsampler can upsample up to 352/384 (DXD) or 2x DSD. For MQA input it will not upsample at all, passing the original data to the DAC for MQA decoding.
Personally, I usually keep it set to DXD, and find this provides an audible improvement. I know some others prefer no upsampling at all though. So to answer your question, yes, the upsampler can provide a benefit for Tidal, assuming you like the sound of upsampling.
I have no experience with the network bridge, but I believe it will also be able to pass MQA data to the DAC. Others on the forum have stated though that even if you don’t want to use upsampling the upsampler still sounds better than the network bridge (which it had better, considering the price difference).