Can you confirm if you are passing the file URL correctly in the HTTP action as I can see you have mentioned the URL as "https://vsrm.dev.azure.com/XXXXX/XXXXXXXXXXXXX/_apis/Release/releases/9481/logs" and I don't see it is the correct path for the zip file. It should be something like https://vsrm.dev.azure.com/XXXXX/XXXXXXXXXXXXX/_apis/Release/releases/9481/logs/ReleaseLogs_9481.zip
If you are passing without the filename then it will download the HTTP response from the requested URL.
I have created the HTTP action and pass the zipped file (not of devoOps release logs) and don't face any issue.
If your file is more than 100 MB then you might want to download the content in chunks: https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-handle-large-messages#download-content-in-chunks