Yes really. A pixel is a pixel. This dell monitor has pixels the size of boulders. Apple Pro Display XDR has 4.6m more pixels in a significantly smaller area creating a much denser display.
macOS can specify regions of the screen to be 1x. If I'm using Capture One or Lightroom, my photos are at normal resolution while the UI elements are "retina/2x".
You can configure macOS to scale everything more or less, just like you want it.
Same for Windows and Linux.
And you keep the crispness of the full pixel resolution for text and images.
What is going on here? Why is everyone in this thread using 'pixels" to mean ppi? It seems unnecessarily confusing or even misleading. I mean blatantly a 6K monitor has more pixels than a 5K or 4K one, regardless of the pixel density.