CDC only records changes, it won't push them into your second table.

You have to write the ETL yourself, but 5 seconds is quite low so you would need to write some pretty fast scripts.

Maybe you can look at other options, such as replication.