I think I finally found the perfect use-case for pixel-shift super-resolution: scanning film.
✓ Subject is immobile, so no motion artifacts
✓ On a 24MP sensor, most film grain is larger than sensor noise after merging, so sensor noise essentially vanishes once downscaled
Here's two scans of the same frame, first done on the lab using a Noritsu professional scanner, and the second done using my Nikon Z6 III pixel-shift mode, then downscaled.