If things were to go on forever, then the Earth would eventually become tidally locked. However, the reality is that in a few billion years, the Sun will continue to grow and grow until it is large enough to pull the Earth in with it's gravitational pull, and end up destroying it.