Maybe you should clarify what company you worked in, because that's clearly not Google. In Google, SREs do 12 hour shifts. Night shifts (or rather 24 hour shifts) are (ironically enough) usually done by SWE teams. Almost every SWE team in Cloud has a 24 hour shift, and I agree, they are quite terrible.

I've had 12 hour shifts at Google with 200 pages over a week (shitty monitoring, shitty capacity constraints, shitty management). That was quite terrible.