There are ways the PS4 Pro and Xbox One X will be superior to it, mostly in the same way they are to the Series S -- average internal resolution of titles is higher on these consoles.
But yeah, games should look and run overall better on Switch 2 than they did on PS4 Pro/Xbox One X when you consider all aspects, not just image quality.
I think the range of quality-per-performance is pretty narrow given what we know, with 8nm vs. 4nm determining if it is at the lower end of this range or upper end (intermediate nodes like 7nm would put it in between.) 8nm probably means Nintendo is going to allow power levels to go much higher in docked mode than they did in the original Switch, because otherwise it doesn't make sense as a node, so that could make up for being less efficient vs. a lower powered 4nm chip.
Z1 (non-extreme) to RTX 3050 (Laptop) includes systems that all perform pretty similarly. Those are basically what you get in entry level $400-$500 gaming laptops or RDNA 3 mini-PCs/handhelds of a similar price. So $400 shouldn't be a stretch for Nintendo, and they might have some budget leeway to add a nicer display.
I don't think most console gamers would complain or really notice the difference between this level of performance and the Series S. It basically amounts to a resolution difference that most casual gamers don't perceive well, especially if DLSS can make up some of the difference by being superior to console FSR.