This sounds like speculation based on a few viral instances. Can you provide any sources? The moon problem you're describing was attributed to a 2023 Samsung, which was using neural upscaling. Can you provide a source describing this for this specific model (Huawei Pura 80 Ultra)?

Computational photography isn't just the smoke-and-mirrors of AI upscaling faking information. You really can get around the limitations of physics on a traditional lens with non-generative computational photography techniques, incorporating real information, like the time-series data over the length of an exposure, the data from other sensors like the accelerometer or lidar, or data from an array of lenses (as others have pointed out).

Even without those tricks, the Pura 80 Ultra specifically uses a much larger camera sensor than most phones.