Comment by mapt

What we're doing here to get higher SNR, generally, is growing the CMOS sensors larger and larger. The limitation is ultimately either depth of field or IC manufacturing issues. A hypothetical meter-wide sensor could be manufactured to combine with a catadioptric lense of extreme cost, but you'd expect most of a scene to be bokeh, like in macro or microscope lenses.

In reality there are limits imposed by manufacturing. At the extreme, we have wafer-scale sensors used in, eg, night-time wildlife videography - https://www.imdb.com/title/tt11497922/ . Anything larger than that is typically a not-perfectly-contiguous array of smaller chips.

You can also cryocool the camera, at the expense of weight, versatility, and complexity. Most astrophotography is collected with cryocooled CCD or cryocooled CMOS sensors. This helps much more with long exposures than it does with video, but it does help.