The Future of Earth: Scientific Insights on Its Ultimate Fate