Just stashing these here for later.

Interplanetary Diaspora:

John Varley's Eight Worlds series

Bruce Sterling's Shaper/Mechanist series

Michael Swanwick's Vacuum Flowers

Wil Mc Carthy's Bloom:

John Barnes' Jak Jinnaka series: The Earth has been attacked by a barage of relativistic meteors, leaving it covered in craters. However, some time has passed, and although there is a wide-ranging off-planet civilization, the home planet is inhabited and thriving again.

Century Rain by Alastair Reynold

The Queendom of Sol series by Wil Mc Carthy

Terraforming Earth by Jack Williamson

The animated movie Titan A.E.

Moonseed by Stephen Baxter

Blade Runner (the movie, not the book)

Diaspora by Greg Egan

Heart of the Comet by David Brin and Gregory Benford

Echoes of the Earth by Sean Williams and Shane Dix

The sole reason in most mainstream sci-fi? Star Trek, Van Rjn/Flandry, Babylon 5, Vorkosigan, Honor Harrington, and on and on, all have Earth perfectly fine and pioneering motivated by economics and politics.