C-script, like everything else in our digital world, will never really disappear. Since you can still find ADA or Fortran II programs running today, I'm guessing C-script will still be around 10-20 years from now.
But Conitec has already stopped adding features to C-script and the next-next-gen engines after A7 will probably not support C-Script.