When the GPU fans spin up that high its because they are trying to keep your GPU (which is under a heavy workload) cool, and so probably the whole system is working hard trying to render the game on the screen for you to play. So it could happend that also CPU and/or case fans also spin up to keep the system cold.
Anyways, I would check the other fans first, and then I will make very sure the noise is not coming from your PSU. Im not an expert but that Cooler Master unit seem to be not the best and could be having a hard time giving power to your new GPU. (Here is the PSU tier list:
https://forums.tomshardware.com/threads/psucultists-psu-tier-list-rev-14-8-12-07-2021.3624094/, I believe yours is in Tier E, then again Im not an expert).
Lets wait for someone else to share thier opinions there are really amazing and smart people here that may have another point of view.
Cheers!