If the apps inside need to be specifically coded for it, then why is it "marketed" as a way to sandbox currently existing apps?

I’m not sure flatpak is marketed at all. Users might describe it like that.

From my understanding if you use GTK or QT it just works but many programs have their own custom file pickers which don’t work when filesystem access has been restricted.