"Because your CMS is rewriting out trailing slashes. Make it stop that, and then you'll be in the relative path you think your in".
The internet uncertainty principle: It's not DNS, it's trailing slashes. (apologies to Herr Heisenberg :)
[1] https://developer.mozilla.org/en-US/docs/Web/HTML/Element/ba...
I have no idea what Vercel, Render, and Azure Static Web Apps even are, but you should obviously be aware of their limitations when using them to host HTML. I'm sure there are plenty of other behaviours that differ between them and there's hardly any universal truth to be found in the decisions some big corporations once made.
This article seems more about the default slug-to-content resolution algorithm from a bunch of cloud providers than it is about trailing slashes.
Use trailing slashes please.