ceevee and killermech's testing and experience has convinced me that the G6 does work the way I expected, that the save is kept in the G6L battery-backed SRAM and not actually written to the (non-battery-backed) cart filesystem until you soft-reset or turn the DS off and on again.
It's a bit of a shame it doesn't save immediately directly to the gamename.0 file in the filesystem, but I guess the technology isn't ready yet to support that. I'm just guessing, but maybe the type of memory that the DS is expecting to access for saves has to be of a fast type, and the normal cart filesystem memory isn't quick enough to be directly accessed by the DS, hence having to use faster SRAM.
Qrayzie is right that in normal usage of the DS and G6L this probably doesn't make much difference. You can play multiple games and turn the device off and on and the saves should 'just work'.
However, there are a couple of situations where you'll need to bear in mind that the save is actually initially kept in battery-backed SRAM. For example, people who only play the DS in short bursts, with a long gap between play sessions, may find that the G6L battery hasn't got a sufficient charge to keep the SRAM save protected until they next switch on. Such people, or anyone else worried about the battery, just need to make sure they soft-reset the DS after saving, or switch it off and quickly on again. The save is then 'permanently' written from battery-backed SRAM to the cart filesystem, which doesn't require a battery to keep alive.
The other time you need to bear the battery-backed SRAM save in mind is if you want to manipulate (e.g. backup or restore) your DS saves from a PC. Again you need to soft-reset or switch off and on the DS to properly write the DS to the cart filesystem, otherwise you won't be accessing the current save. (Obviously the actual save is stored somewhere on the cart, in the SRAM if this theory is correct, but I'm assuming that the SRAM is hidden and not accessible via the cart filesystem interface).
Some questions relevant to his theory - does anyone know:
1, How long the G6L battery will keep the save for, if the battery is fully charged? Is it hours, days, or weeks?
2, How long does it take for the G6L battery to charge?
3, Is the G6L battery charged while plugged into the DS or when plugged into the PC, or both?