It depends totally on the horse and the situation. My family have sold two horses so far, one to an incredible home where she has three kids and a mother who adore her and do everything for her, even though she can't be ridden now (previous tendon injury), the second was Sunny an overly neurotic TB who found an amazing home in which he passed away last year.
In saying that, both of my horses are staying for life. I have that duty of care for them, and both of them are "interesting. Sparks is older with dodgy knees and will never be a learners pony, Tally is 13 but arthritic hocks and behavioural problems. I don't think I could sell either of them on and feel happy with that decision as I know their problems. Tally perhaps I'd loan.
Personally, I believe that it depends on the horse. If you have a show-jumper in the prime of its life with no health problems, then it's perfectly acceptable to sell it on so someone else can enjoy it. An older pony who is sane and sensible may make a fantastic first pony for a nervous child. However, it's the horses with issues, health or otherwise, that I believe the owner needs to take responsibility for, in whatever way that is.