There isn't a built-in automated way within the Cloud Data Fusion UI to change the compute profile for hundreds of pipelines simultaneously. The UI is designed for individual pipeline management.

But you can achieve automation through scripting. This would require using the CDAP REST API to programmatically update each pipeline's configuration to point to your new profile. This approach necessitates familiarity with REST APIs, scripting, and potentially JSON manipulation to handle the pipeline configurations.