SMS: Breaking Boundaries with Ceramic Matrix Composites: A Comprehensive Overview of Materials, Manufacturing Techniques, Transformative Applications, Recent Advancements, and Future Prospects