DiracPool said:
What does this space-time diagram look like?
It depends on what you want to emphasize. The underlying issue here is that, in curved spacetime, there is no way to draw a spacetime diagram that has all the properties that you are used to from SR. In particular, you can't draw a diagram that has both of the following properties: (a) all straight worldlines are unaccelerated, and (b) distances between neighboring straight worldlines are constant.
Your initial thought, that we would just draw Earth's worldline as a straight line and yours as another straight line, is fine if what you want to preserve is property (b)--i.e., you want the diagram to reflect the fact that you are stationary with respect to the Earth. But, as you saw, that diagram lacks property (a)--your worldline is a straight line in the diagram, but it's accelerated.
You could also draw a diagram in which property (a) held, i.e., straight worldlines were unaccelerated. (Such a diagram actually could not cover the entire Earth, as I'll discuss in the next paragraph, but we'll ignore that complication for a second.) In such a diagram, your worldline would not be straight: it would be curving away from the Earth, just as the worldline of an accelerating rocket in flat spacetime does in a standard SR spacetime diagram. But also, in such a diagram, property (b) would not hold; you are accelerating upward, but you're not moving away from the Earth, even though the diagram makes it look like you are.
There is actually another problem with the second diagram, the one I described in the last paragraph. As I mentioned just now, it can't cover the entire Earth. That's because, in curved spacetime, unaccelerated worldlines that start out parallel can end up crossing! For example, suppose there were two tunnels running all the way through the Earth, with endpoints separated by some fairly short distance at the surface. Consider two rocks momentarily held at rest at the endpoints of the two tunnels, and then released into free fall. The rock's worldlines would be straight in the second type of diagram (because they're in free fall). And they would start out parallel, because the rocks are initially at rest relative to each other. But both rocks would fall through the center of the Earth, so their worldlines would cross there. There is no way to represent this on a spacetime diagram where unaccelerated worldlines are always straight, because straight lines that are initially parallel in such a diagram will have to stay parallel forever, so they can never cross.
What I've just described is one way of showing, independently of any specific choice of coordinates, that spacetime near the Earth is curved: initially parallel straight lines not staying parallel is the definition of "curvature" in geometry. And drawing a diagram of any curved surface is going to present similar issues to the ones you've discovered. There is no way to "fix" them; you just have to accept that there is no one "spacetime diagram" that can represent all of the properties of curved surfaces in an intuitive way. You just have to pick the kind of diagram that works best for each particular problem.