The Flight Safety Foundation has done a lot of work on CFIT accidents. The risk of a CFIT in a non-precision approach is five times higher than in a precision approach.
It should not be a problem for properly trained flight crew to fly a non-precision approach into the Comores during day-time. The issue is however whether the risk of flying the non-precision approach into the Comores at night-time and in bad weather is not too risky even for well trained and qualified flight crew? This is something which is normally assessed as part of risk management within an airline's Safety Management System and this is also the reason why many airlines have decided not to fly to the Comores at night (and certainly not in bad weather conditions).
Off course the accident investigation will need to identify the reason for the Yemenia crash