Whats going to happen to the horse now?

It depends who is in control of his will, but the next of kin may ask the stable management to sell the horse on to a suitable home.