You asked
Is the sony rx1 good in low light?
Here is what the site says about that.
From Sony RX1: Sony RX1: A fixed-lens compact by Sony with a 24.3-megapixel full frame sensor, announced in 2012. A full-frame compact with a fixed 35mm f/2 lens. Specs - Maker: Sony - Lens: built in, 35mm f/2 - Sensor: Full frame, 36 x 24mm, crop factor 1.0 - Resolution: 24.3 megapixels - Stabilisation: none - Announced: 2012 - Type: fixed-lens compact Focal lengths on it Its 35mm lens frames like 35mm on full frame, ...
From Sony a7S III: Sony a7S III: A mirrorless camera by Sony with a 12.1-megapixel full frame sensor, announced in 2020. Built for video and low light; 12 megapixels is little for stills.
Quoted from this site's pages.