But what makes the Constellation refit such an incredible waste and perfect sample of Sunk Cost Fallacy is the PP-cost.
As others have already pointed out, you misunderstand the resource cost of upgraded ships.
And since the 2d6 generate results on a bell curve, +1 stat to a low stat ship is actually a BIG improvement.
However, I do agree that the pp cost last snakepit was too high now we have the ConnieB. However, as the Constellation refit's pp cost comes down, upgrading these ships will be very rewarding.
I prefer refitting the old Centaur-As, because it conserves crew and resources for (short term) when we start building Constitution-Bs and (long term) our continued production of Centaur-As and Excelsiors. Also, war is likely more than a year away- but might be less then 3-4 years away. Any ships we can refit now, it'd make sense to refit now rather than waiting.
We can't refit Centaur As - the Centaur A IS the updated version of the Centaur.
fasquardon