Well he didn’t want her dead. Finn confirms this, with the info from D-O that Ochi was supposed to bring Rey to Exegol. I guess you could say that he wanted to raise her as his predecessor but when he lost her he switched to Ben.
At some point though you have to ask if he just supremely lucked out that Rey came back into the picture by herself?