That's how it works.
These additional Leaderboard snapshots are totally optional. You have to manually create/save them one by one, by clicking in UI, and manually delete them by clicking wipe in the UI.
They serve no in-game purpose and are only there for people who might want a snap shot of the leader for each category at a specific time, like at the end of an event for example.
The main ranks table is the one that constantly accumulates stats and is viewable in-game and, with the settings you have above, should automatically wipe when you first load a new map. If you're using SQL to mirror the main stats then, with your pasted settings, that table should have been automatically dropped too,
meaning that local + SQL main data both reset.
Is that not what happened?