Error message You can’t open the application “Adobe Installer” because PowerPC applications are no longer supported. when trying t download CS 2.

The message means just what it says I'm afraid. CS2 was designed to work with the old PowerPC processor which Apple haven't used for years. Modern Macs use an Intel processor and can't run CS2. There's nothing you can do about it.