In normal times the RER from CDG is fine...yes it does not pass through some of the nicest neighborhoods, but I have never felt any danger. Still, I much prefer the Air France Bus ('les cars Air France').
However, with the way things seem to be headed I would avoid the RER for the next couple of weeks - as well as any trips to Le Bourget to the air museum!