(Note I am considering every transformation here as a passive transformation, i.e. as transformations of globally defined coordinates rather than transformations of the actual spacetime. This is very important, because the reasoning here applies to passive transformations only!)
If you're asking what passive transformations preserve what the spacetime interval actually is, then all possible coordinate transformations preserve it, because the spacetime distance between any two events is a coordinate-independent notion.
However, if you're asking about what passive transformations preserve the way the spacetime interval is written, then the answer is that it is the Poincare group (reinterpreted not as group of isometries but as a group of passive transformations). The transformations from the Poincare group preserve the form of the spacetime interval as
$$ ds^{2} = -c^{2}dt^{2} + dx^{2} + dy^{2} + dz^{2} \qquad (*) $$
in Cartesian inertial coordinates.
The Poincare group is the group of all (1) Lorentz boosts, (2) rotations, (3) translations, and (4) reflections, and these are the only passive transformations that preserve the way the spacetime interval is written.
Again, I emphasize that there is a difference in asking what changes the spacetime metric vs asking what changes the way the spacetime metric is written. It is extremely important to understand what is coordinate-independent and what is not.
This gets us to another question you posed.
Then why are coordinate transformations such as Cartesian → spherical not included in this set, despite the fact that the spacetime interval / proper time is unchanged (since the space coordinates x, y, z are simply being re-labeled, while time stays the same)?
The Cartesian → spherical transformations are not included, because they change the way the spacetime metric is written. In spherical coordinates, the spacetime interval is
$$ ds^{2} = -c^{2}dt^{2} + dr^{2} + r^{2}d\theta^{2} + r^{2}\sin^{2}\theta d\phi^{2}. $$
Clearly this is not the same form as in $(*)$, so this transformation is not in the Poincare group.
So to summarize,
- All coordinate transformations of any kind (no matter how crazy and weird) preserve the spacetime distance between two events, because the spacetime distance between two events is coordinate-independent.
- Only transformations of the Poincare group preserve the way the spacetime distance between two events is written and calculated.