You asked
Is the sigma 15mm f 1 4 dg dn diagonal fisheye art good in low light?
Here is what the site says about that.
From Sigma 15mm f/1.4 DG DN Diagonal Fisheye Art: Sigma 15mm f/1.4 DG DN Diagonal Fisheye Art: A prime lens by Sigma for Full frame cameras, 15mm f/1.4. A fast full-frame fisheye, made with night-sky photography in mind. Specs - Maker: Sigma - Focal length: 15mm (prime) - Maximum aperture: f/1.4 - Made for: Full frame sensors - Mounts: Sony E, L-Mount - Stabilised: no - Autofocus: yes What it frames like - On full frame (Sony E, L-Mount): as marked, 15mm. - On APS-C (Sony E, ...
From Sensor sizes: Is full frame worth it?: For low light, events, and portraits with very shallow depth of field, yes. For travel, street, wildlife on a budget, and most hobby photography, a good APS-C camera with good lenses is enough, and you'll carry it more. Lenses and light matter more than the last stop of sensor performance.
Quoted from this site's pages.