The implementation on my Google Pixel 3a definitvely is not meant for a tripod. In a simple test I did once, it definitively produced a better straight out of camera result of a static scene than my 80D + Sigma 35 mm 1.4 were able to deliver hand held in that situation. With IS and IBIS thrown into the mix, it becomes a more fair comparison of course and as I said, that was not a proper test. Still, the results are impressive. No surprise really, as I use the same technique of stacking numerous shots to reduce noise in Astro all the time.I do not find that to be true at all.
Try shooting in RAW and editing the photo in post.
The IBIS in the R5 even allows for longer handheld exposures.
"Night Shot" is meant for a tripod anyway.
I'd also like to see the camera companies to offer some of these automized processing techniques, rather than relying on the user performing them manually in post. That's not the same as as strpping the control away from the user. Ideally a format to save this in would keep the underlying raw data in tact and allow tweaking of the processing steps. Of course it would require using proprietary software. But Canon has already taken some baby steps into that direction.