Megatron's life after the show is not publicly known, but it's likely he continued to live with Big Black. There haven't been any reports of his passing or being rehomed.
It's worth noting that mini horses are often kept as pets, so it's possible Megatron continued to be a beloved member of Big Black's family.