Sorry to kind of hijack this thread, but I'm also in a bit of a stereo related pickle

π«
I also have a 2001 JDM C5 and it has a terrible Japanese Pioneer Carrozzeria double din fitted which drives me insane!
It's all in Japanese with no way of changing to English, the nav still thinks its in Japan, it overheats and shuts itself down after a while too (due to age).
So time to change it
I've bought a new double din which will basically enable me to mirror my phone, so very handy for using things like google maps/waze, music etc. But I honestly haven't got the slightest clue where to start in terms of wiring fitment needs?!
I will be keeping all the factory speakers.
I've done a bit of online researching but I'm not really finding any clear or solid answers

The last time I fitted a stereo to an older vehicle, it was as easy as buying an ISO lead which simply connected to the cars factory wiring/plugs, and then directly to the rear of the new stereo with no fuss whatsoever

I haven't removed my stereo yet so I've no idea if it has any butchered wires from the current aftermarket install?
I know how to get to the current unit fine, but I'd like some advice on what to expect to find (if I'm lucky and all's not been messed with... too much), and what's the best way to attack this stereo swap?
Anything I might need to purchase to make my life easier and so on?
A wiring diagram or explanation of what colours do what... might be a big help?
Thanks
p.s. I assume it should of had some sort of install to the wiring to allow the factory stereo to be swapped to a Pioneer double din Nav unit, and to run with all the factory Bose speakers???
But please correct me if I'm wrong