If you consume too much Sodium Benzoate then it can be harmful to you.
But to be affected by the Sodium benzoate you would have to consume large amounts of the food containing sodium Benzoate or be drinking gallons of soda for it to be a problem.
Sodium Benzoate is not really healthy but not that harmful in small doses so I wouldn't worry too much.