How do I change the default drive for the Adobe products to the D: drive?

It will be difficult or impossible to use Creative Cloud effectively with a tiny C drive almost full. Though you can move the main install folder, that's only a small part of the need.

Hi

You can change the install location in the Creative Cloud preferences, you will need to uninstall and reinstall

You have to take into consideration that depending on which apps you use some apps will require temp storage space on your C drive, for example Photoshop requires space for the scratch disk, Premiere Pro and After Effects require space for the Cache which is defaulted to the C drive etc