You can run the stockpile dry - outposts start out with 25k common ore (the resources put into building the outpost ship) stockpiled that you can harvest, but you can never run a planet completely out of resources to where it's useless - they have resource generation rate so they'll always produce more, though how fast they do so will depend on the planet.