The newer ECU maps actually pull out more ignition timing when using the low octane maps, so should be a bit safer, assuming the ECU does actually switch over.
Most knackered pistons are due to knock or something going through the engine. That pic definately looks like knock damage.
Going by what Mark has posted before, even the high det/low octane map doesnt pull enough timing for 95RON fuel above ~5kRPM. I'm sure there have been posts where he said he's had a car on the dyno not realising it had 95RON in until he heard all the det that was happening, and the car was in the high det map at the time.
Nissan categorically state not to rev the car highly when you have 95RON in it. It is designed to get you to the next garage with Super at it. So can be safely driven slowly (low revs) but as soon as you rev it the high det map still wont save you.
Thats what I've gleamed over the years from what people have posted from their observations