I'm sure that Google internally is well aware of the negative press that comes with product shutdowns, and is doing them regardless as a deliberate strategic tradeoff where they believe the benefits outweigh the costs.
But it's very difficult to measure the costs, bc the #1 cost is lost trust, and how do you measure that? Many people simply won't sign up for a Google product bc they don't trust it'll be around long enough to justify the investment. These people don't show up in any metrics that you can reason about, and they're the least likely to take any surveys you might send out. At best, Google can guess what the impact is, and they might be wildly underestimating.
I think a different strategic decision they could've made (and still could make!) would be to the do the opposite, and prioritize the benefits of keep projects alive over the costs of ruthlessly sunsetting then.
They could say, "You know what, we have considerable resources. When we release something new, we're going to dedicate ourselves to keeping it running indefinitely." They wouldn't have to market them, or advertise them, or connect them to every new part of the evolving Google ecosystem, or make them particularly easy to find, or even keep them open to new signups. But just keeping them running as-is, indefinitely, and having customers tell each other, "It's Google, you can trust it, it's not going away," would be such a great PR win.