Si, I hope you won't let this sad accident put him (or indeed you) off. As said above, the vast majority of cadets join up because flying is what they want to do, and it is such a fantastic, life changing experience. My heart goes out to the families, blood and extended, who will be feeling the aftermath of this accident keenly.
They shall not grow old, as those who are left grow old....