The aerodynamic benefit of using a tail cone on a high-powered rocket mainly revolves around reducing drag and improving the rocket's overall aerodynamic efficiency. Here's a detailed look at these benefits and the consideration of the additional weight:

Reduced Drag: A tail cone can significantly reduce the base drag, which is the drag produced at the rear end of the rocket. In the absence of a tail cone, the abrupt end of the rocket creates a low-pressure zone, leading to increased drag. A tail cone helps streamline the airflow, thereby reducing this base drag.

Improved Aerodynamic Efficiency: A tail cone enhances the rocket's aerodynamic efficiency by smoothing the airflow around the rocket's body and minimizing turbulent wake. This is especially beneficial during the supersonic phase of the flight, where drag becomes a critical factor.

Weight Considerations: Adding a tail cone adds weight to the rocket. However, the key is to design the tail cone so that its weight is minimal compared to the aerodynamic benefits it provides. Advanced materials and design techniques are often employed to keep the weight low while maximizing aerodynamic efficiency.

Aerodynamic Stability: The additional weight at the rocket's tail due to the tail cone can impact the rocket's centre of gravity (CG). To maintain aerodynamic stability, adding compensating weight at the nose might be necessary. The overall design goal is to ensure that the rocket's centre of pressure (CP) is behind the CG. This is crucial for stable flight.

Trade-Off Analysis: Using a tail cone involves a trade-off analysis between the added weight and the aerodynamic benefits. Engineers use computational fluid dynamics (CFD) simulations and wind tunnel testing to quantify these benefits and make informed decisions.

Overall Performance Improvement: Despite the additional weight, if the tail cone significantly reduces drag, the overall performance of the rocket in terms of range, fuel efficiency, and payload capacity can be improved. This is particularly relevant for high-powered rockets where aerodynamic efficiency plays a major role in mission success.

In summary, while a tail cone adds some weight to a rocket, its primary purpose is to reduce aerodynamic drag, leading to greater efficiency. The overall benefit of a tail cone depends on its design and the specific mission requirements of the rocket. The goal is to achieve an optimal balance between the added weight and the aerodynamic improvements to ensure the best overall performance.