Cooperative Profiles Predict Multi-Agent LLM Team Performance in AI for Science Workflows