It's funny how people expect less details and worst LOD on XSX because its SSD is slower...
Remember that its SSD will be 70-80 times faster than current gen HDDs with almost inexistant access time (compared to 10-20 ms on 2.5" HDDs), their's no way LOD and pop-in will be affected by a "slower" SSD than the PS5...
You're setting your expectations way too high, maybe only the first loading time will be slower by a second instead of two on PS5, that's all.
Even on PC slower NVMe drives are not fully exploited by games and the system unless copying tons of data, which optimized games don't do.
(I know those consoles architectures will use the SSD more efficiently but still, games won't need to load dozens of GB to load a map).
Streaming data in a open world rely a lot on CPU, sometimes more than storage, the more data to process, the more CPU it will use.
On XSX we already have somewhat of an example of what it's capable to do, when switching Xbox One X games on the fly with Forza Motorsport 7 and others. It loads it from a copy of the RAM on the SSD, but remember that it has to write the current game's RAM data on the SSD before loading it (to save the current game state), it only take a few seconds to switch from game to game (using up to 9GB of RAM).