This would mean Sony would almost certainly get Kojima back to work on a new Metal Gear and...yeah with the bad blood between Konami and Kojima I don't think their pride would even let them be bought out. I could see a situation where Sony basically funds and publishes a new Castlevania or possibly Metal gear and it remains exclusive on PS and PC but I don't know about them being bought outright.
And while Metal Gear and Castlevania are big franchises, I don't think this aquisition would make anywhere near as big of a dent as Microsoft's acquisition. The only thing that could send shockwaves throught the industry like this is if Sony buys Take Two Interactive and yeah, I don't think Sony's financials are in order to do anything of the sort.
I just wish someone, preferably Nintendo, would take Hudson Soft's IPs off of Konami's hands. They're just rotting there.