Why was it retired?
Wikipedia briefly mentions a fatigue test done to extend life by 11,000 hours to keep USN’s in service until 2009.
Wikipedia points to usefulness potential today including refueling fighters to get more range for protecting aircraft carriers against emerging longer range weapons. (US naval oriented services use C-130s for refueling helicopters, they go 350 knots at modest altitudes, have been demonstrated on carriers, J model has more power but also more weight due longer fuselage.)