Every SD Card in the market has a limited number of write cycles. This is a measure of the cards hardware lifespan. Writing and deleting is done by current that it is transferred through the SD Card cells, which gradually cases them to wear out. The lower the voltage required the greater the life expectancy of the SD Card.
SLC require lower voltage levels compared to the other types. But even those are going eventually to fail. To give you some rough numbers, SLCs are estimated to have around 100,000 write cycles. Where MLCs range around 40,000 and TLC as low as 1500.
Another parameter that should be taken in to account is the storage size. If you have to SD Cards of the same type ,lets say for example the one is a 32GB and the other 64GB, it will take twice as long for the second one to reach the write cycle limit resulting in a longer life span.
Conclusion is that you will still get a longer lifespan and you will be more secure with a higher grade SLC card. And since we are talking about security cameras data it is an unnecessary risk to take with a cheaper TLC card.