I think a big chunk of the reasoning is that Sony will want to protect their access to certain IP. 

Final Fantasy has been a reliably big franchise for them for a long time. It's no where near GTA big, but that means it's much more affordable. 

Even though the overhead costs would rise, they would also get more income. Square is a decently profitable company right now. 

NOOOOOOOOOOOOOOOO!!! I wonder if Sony might pull out of the deal

We don't know the contract, but it is possible.

Or they go full nuts, hire Amy while studio purchase is being finished by sony.

I know Aspyr was an odd choice from the start considering the studio had never done anything outside of porting the really old Star Wars games to modern systems, but I was figuring with the kind of backing the game had, all the necessary resources and staff would be there to ensure the project would succeed. Guess not. Sounds like Aspyr is going to have to finish this project one way or another though.

EDIT: Not a fan of Saber Interactive games either. So if it's true that they take over the project from Aspyr, that doesn't leave me with much confidence I wonder if Embracer Group is regretting purchasing Aspyr lol

I'm not sure if this is validated by the studio founder. But SE is a good get. It's not just about getting SE's heavy hitters. 

They could make FF entirely exclusive (something which only mainline titles are). They could make the AA titles that usually go to Nintendo exclusive. Those titles are made from 3rd parties so it builds and expands Sony's partnerships with a lot of studios they most likely don't deal with directly. It gets them Taito and every IP that belongs to them. Another important area is classic titles to build up their highest tier on PS+: it's very clear that SE would prefer to remaster these titles (and thus make them available everywhere. 

There's a lot of benefits content wise for Sony to get SE rather than continue their current deals. 

Surely part of the equation. But honestly, I don't really see what Sony gains from CD. They haven't pushed TR in any meaningful way forward, Avengers was a bad game (even taking away the GaaS aspects), part of the studio is still working on Avengers while another part is working on an Xbox game, and their next title is seemingly another TR. There are better more meaningful ways for Sony to use their money imho. 

Too bad. I feel for Asphr. This was the opportunity to really push to another level and clearly some individuals did a poor job managing their work. I can see Sony potentially pulling out. It'll be interesting to see what happens but I feel this game is dead. At the very least, maybe we'll see the ports of KOTOR 1 and 2 come to PS4/ PS5 now. 

I wouldn't put it past current Sony to keep the Switch games, but also bring those games to PS4/PS5. Could be good perks for PS+, without interfering with how SE makes money.

They would definitely make Final Fantasy exclusive though, seeing as they already are. Not to mention, big AAA games like Forspoken.