There seems to be a bug in Athena / Glue related to partitions that contain whitespace.
In my original table, I have a paths that look like this:
bucket/prefix/partA=123/partB=2025-01-01 00:00:00/partC=xyz/parquetfiles
if I re-create the table so that the paths look like this:
bucket/prefix/partA=123/partB=2025-01-01/partC=xyz/parquetfiles
Everything works as expected.