Well, it also happen to me but I just put the rendered video on filmora and export from there, it come to be very low storage
I don’t know why after effects do this there was a video of just 8secs it was taking 1.4 GB
I just put it on the filmora and exported it it come out to be 9 MB file