I really hate the name 'super' capacitor, as it encourages people to think they are particularly useful - when in reality it's just a very poor imitation of a battery.
Anyway, as far as this circuit goes it looks 'OK', but it will only give a fairly short backup time, and the capacitor will probably fail after a couple of years. They were used extensively in cheap VCR's for this same purpose, and it was an EXTREMELY common fault - I've replaced hundreds of them.