As for the results? They’re not perfect (you’re looking at one example up top), but they’re miles above what you’re used to from your handset. Google’s Nexus 6P and Pixel could take well-exposed, color-accurate and largely noise-free photos in extremely dark situations. Kainz even managed a decent photo of the night sky using nothing but starlight. The approach can compensate for motion, too, so you might not need a tripod to stabilize your phone.
Right now, the approach isn’t practical for most people. It requires a lot of after-the-fact processing on a computer, and the pictures still aren’t as high-resolution as what you tend to get out of DSLRs. Also, you certainly wouldn’t want to use this for fast-moving objects. However, Kainz believes that a phone could handle everything by itself with the appropriate app. If the experiment translates from Google’s labs to real-world code, you could take many nighttime photos that are virtually impossible today.