Well this is very dependent on the specific details of the body.

We've seen that bodies with a large deviation on their surface tend to become tidally locked with what they're orbiting. Ex. The moon became tidally locked with earth and Venus became tidally locked with the sun. Earth and other large planets will probably also eventually become tidally locked as the deviations in their surface slow down their spin and turn a specific face towards the object they're orbiting.

There's always the chance of collisions especially for larger bodies like planets

The sun the body is orbiting will continue growing and for objects close like the earth they'll probably get consumed by it or have their atmosphere shredded off by intense solar radiation as it grows

In most simulations objects orbits tend to get more and more chaotic with time usually ending in them being launched from system

And of course eventually our sun will die. If our star was MUCH more massive it might make a supernova, maybe even a black hole. But for smaller stars like ours it'd probably just release a burst of hot cosmic gas and die.

Basically eventually rocky bodies if not consumed by their star, ejected from the system, or collided with another body, it'll probably sit boringly orbiting a dead star; it also dead with no atmosphere spin or magnetic field.