Welcome bemehay,
The big majority of bladder cancer people diagnosed do survive. By the fact he is on BCG that means it is not muscle invasive or advanced further means his survival stats are even better. I don't care for stats anyway. As with most cancers, catching it early greatly increases living. Chances are good something else will get us. I am a survivor of almost 16 years.
I presume he is getting BCG because his is high grade which does add a little more risk. Keep in mind there are usually 2 types DX from papillary (mushroom like) to CIS, which is a flat, reddish lesion. That is what I had. I trust BCG works and you simply need to follow whatever regimen with follow up cystoscopes and he should be good. One added note. BCG often has tolerable but uncomfortable side effects. If this happens it usually means it is working. Also, remind yourselves that this is a lot better than taking systemic chemo.
Post as you go with other questions.