Just look at the tribute the Red Sox put on for Jeter and the ovation he got.
I think he'll definitely be cheered and honored. And as with Jeter/Red Sox, I think it helps that one team is at the bottom of the league and the other team isn't really a contender, and that it's also been a few years since they had a heated head-to-head match up.