Lucas,
If it is just this one date via the aggregation (which I am also having trouble accessing) then you should try to query the date/time directly via the unaggregated dataset listing that also has an OPENDAP/NCSS access method.
The trick is computing the tau (tHHHH) offset to get the right time you are seeking. The model is run at 12Z so that is the start of the tau offset. if you want 03Z then that is from the previous date/run 20240827 with a tau of t0015 (e.g., your original date/time request, time=2024-08-28T03:00:00Z). I think I got this right...
e.g., a much simplified NCSS URL with no time defined, as there is only a single time in the direct file method.
Let us know if you are encountering these NCSS aggregation issues for other dates/time or if this was the only one you have come across.