Raising children away from your native culture isn't the deal breaker you imply. There are international schools (though, with eye-watering fees) and expat enclaves in most places I've been.
But very few (effectively zero, though I did come across a handful of exceptions) companies treat these employees the same way as the ones back in the home country. If you don't rotate back to HQ in ~3 years then you're in a career dead-end. So you've got this situation where you need people who are ultra-ambitious -- willing to throw away all their existing social networks to go work in a foreign country for years on end! -- but that means those same people aren't going to want to stay past their expiration date. And companies know that, too. A lot of them make it an explicit part of the deal. I met one high-level guy (regional CTO I think?) at Coca-Cola who was Indian and the deal with corporate was he'd do 3-years in a low-income country (not India) but then he'd get transferred to the US. Met some people in the oil industry who had similar deals. Do 2 years in Vietnam then you get to go to Malaysia or whatever.