Carbon-Fibre-Reinforced Carbon–Silicon Carbide Composites for Extreme Environments: A Critical Narrative Review of Processing Strategies, Interface Engineering, Oxidation Resistance and Engineering Applications