What we call the "curvature of spacetime" has a technical meaning; the equations that describe it are very similar to the equations that describe, say, the curvature of the Earth's surface in terms of latitude and longitude coordinates, or any other pair of coordinates you might choose. This "curvature" need not manifest itself as a physical curve "in space".
For the rest of this post let's restrict our attention to 2D spacetime, i.e. 1 space dimension and 1 time dimension, i.e. motion along a straight line. …
In the absence of gravitation, an inertial frame corresponds to a flat sheet of graph paper with a square grid. If we switch to a different inertial frame we "rotate" to a different square grid, but it is the same flat sheet of paper. (The words "rotation" and "square" here are relative to the Minkowski geometry of spacetime, which doesn't look quite like rotation to our Euclidean eyes, but nevertheless it preserves the Minkowski equivalents of "length" (spacetime interval) and "angle" (rapidity).)
If we switch to a non-inertial frame ([an accelerated observer] but still in the absence of gravitation), we are now drawing a curved grid, but still on the same flat sheet of paper. Thus, relative to a non-inertial observer, an inertial object seems to follow a curved trajectory through spacetime, but this is due to the curvature of the grid lines, not the curvature of the paper which is still flat.
When we introduce gravitation, the paper itself becomes curved. (I am talking now of the sort of curvature that cannot be "flattened" without distortion. The curvature of a cylinder or cone doesn't count as "curvature" in this sense.) Now we find that it is impossible to draw a square grid to cover the whole of the curved surface. The best we can do is draw a grid that is approximately square over a small region, but which is forced to either curve or stretch or squash at larger distances. This grid defines a local inertial frame, where it is square, but that same frame cannot be inertial across the whole of spacetime.
So, to summarize, "spacetime curvature" refers to the curvature of the graph paper, regardless of observer, whereas visible curvature in space is related to the distorted, non-square grid lines drawn on the graph paper, and depends on the choice of observer.