Yes I'm sure so many teams were beating down the door to trade valuable prospects for one year of a guy with a 6.79 ERA in 2023 who walked 5.6 per 9, and seemed to fold under any pressure. Switching out guys on the 40 man bubble for prospects would've returned marginal ones at best, and people would've bitched about that, too. GMs aren't going to overpay for performance several years out of date, nor are they going to just buy the "his FIP was so much lower so give me good prospects!" argument either.
Soroka was a good flier to see if he could recapture some of his 2019 success. He ended up being a solid bullpen guy and I wouldn't mind seeing him back, though since he elected free agency that's probably not an option.
Schuster produced 1 WAR in 73 innings as a long man/spot starter and should be an ok arb eligible addition going forward for a bad team.
Lopez did what he was expected to - play good defense at a non-premium position and not hit at all. He was brought in to likely fill in a gap until the Sox felt guys like Sosa were more ready. If he's back I'll be really surprised.
Shewmake sucks and likely won't be with the team. At best they'll stick him in AAA. He was a former first round pick, though, and is the type of guy the Sox should be running through to see if they can get anything out of them.
Gowens was age appropriate for AA and pitched solidly. He also strikes out over 10 batters per 9. He'll probably be in AAA next season and could end up being a useful bullpen guy. Not sure he's a starter long-term, but we'll see.
Bummer rebounded nicely with a team that could play defense and actually scout. His contract extension has no bearing on the value of the trade.
Overall, the trade was fine.