There seems to be an issue with this task, most likely how CsvHelper is used that blocks the co-opeartive unloading of Process AssemblyLoadContext when a never version of the Process is Deployed.
Couldn't find anything concrete with a quick memory dump analysis but there might be something simple in the source code of the Task like something not disposed of correctly.
It could be this reader not being disposed.
https://github.com/FrendsPlatform/Frends.MicrosoftSQL/blob/main/Frends.MicrosoftSQL.ExecuteQueryToFile/Frends.MicrosoftSQL.ExecuteQueryToFile/Definitions/CsvFileWriter.cs#L43