The only thing about moving Mayer is that out of all the everyday positions we have, middle infield looks not only the weakest, but also lacks in quality depth. While corner infield lacks more in depth, Devers and Casas look so entrenched, that area seems like the one we don't need much depth, except to cover for injuries. (Maybe Meidroth is enough.)
While the Rafaela-DHam-Romy-Sogard combo has brought some stability to the middle infield, while Story has been on the IL more often than not, and those higher on the depth chart to start the season (Grissom, Reyes, EValdez) all flopped, they should not be viewed as long time solutions to the SS and 2B slots.
Rafaela belongs in CF, despite the OF bottleneck of talent and minor league depth.
A DHam-Romy platoon at 2B is not bad, but I do not like thinking that should be the plan for 2025 and beyond. (Sogard should only be viewed as decent minor league emergency depth.)
Now, maybe Campbell can play 2B well enough to fill that need, but with Story's injury history, who can we count on to play decent SS? Not DHam. Not Romy. Not Sogard for any long term role. It basically has to be Mayer, until Arias arrives.
While I like Anthony much more than Mayer, our OF is all set, and if Campbell looks better in CF/LF than 2B, we have an even bigger bottleneck in the OF.
LF: Duran, Abreu/Ref platoon, EValdez/Yoshida in a pinch (Campbell, Jh Garcia, Cespedes)
CF: Rafaela, Duran, Anthony (Campbell, Jh Garcia, Bleis, Cespedes)
RF: Abreu-Ref platoon (Anthony replacing Ref for 2026, but is a lefty bat, too) (Bleis, Campbell, Jh Garcia, Cespedes)
To me, it makes more sense to go for broke on the best, young SP'ers we can trade for- a guy with 3+ years of team control. A guy that will demand a stiff return package, headlined by Anthony.