Update: Okay so I decided to approach this from a completely different POV.
Instead of relying on ACF functions, I spoke directly to the DB.
Here is my result so far.
I’m sure there is probably an easier way so if anyone has any advice on how to polish this, feel free to drop in.