When you see an AliExpress offer of an antenna claiming a frequency range from 700MHz up to 6GHz, you can be pretty sure it is a lousy antenna!
yes, this is just a piece of wire, but it still can be used as antenna for a strong signals, for example if you don’t have a suitable rusty nail or other piece of iron in your shed
Good resonant antenna has Q about 10 or more, it depends on your requirements for bandwidth. More wide bandwidth leads to a low Q and as result to a low sensitivity. Some short wave magnetic loop antennas have Q up to 2000 and even more, but they have very sharp resonance and very narrow bandwidth (5-10 kHz). This is how it can hear very weak signals despite the fact that it has too small size.
Antenna bandwidth, VSWR and Q-factor are all linked together, so if you increase antenna bandwidth you will lose VSWR or Q and vice versa.
Here is equations:
VSWR = (Q^2 * BW^2 + SQRT( Q^2 * BW^2 * (Q^2 * BW^2 + 4) ) + 2) / 2
or
BW = (VSWR-1) / (Q*SQRT(VSWR))
where
VSWR - worse VSWR within antenna bandwidth interval around center frequency
Q - is Q-factor
BW - is bandwidth relative to a center frequency: BW = bandwidth_in_Hz / center_frequency_Hz
In short, good resonant antenna works as a bandpass filter. It cut-off unwanted frequencies and it allows to get signal-to-noise gain because noise floor drops down. More low bandwidth leads to more noise cut-off and better noise floor, better sensitivity. But if antenna is wide bandwidth it will pass more noise power on it's output and you will have very high noise floor and as result low signal-to-noise ratio and low sensitivity.
Regarding to the original question, I'm not sure if RF Explorer 6G COMBO+ can work as SDR, but at a glance it is marketed as a usual spectrum analyzer. Why do you think that it can work as SDR? There is even no mention about SDR on its site...
If we compare ADALM-PLUTO with HackRF, then ADALM-PLUTO is obviously better, because it has better dynamic range.