Microsoft 365 Apps Update stuck at 50 percent download with SCCM Error 0x800D000E or 0x8000000E

Recently came across a few devices failing the M 365 Apps Update for x86 based edition version 2404 (Build 17531.20152). Microsoft 365 Apps Update stuck at 50 percent download with SCCM Error 0x800D000E or 0x8000000E.