Don’t forget the old Gearing class!
Sorry to burst your bubble, but the Gearing wouldn’t be good either. Not economically viable to upgrade it to where it could provide significant firepower or fight in sync with the rest of a modern carrier battle group - and without that, it is a gaping hole in CBG air defense and a munition magnet.