apt and dnf inside a template get network through the Qubes OS update proxy at port 8082 on localhost. The template itself is always intentionally offline.
So your flatpack installer cannot connect to the internet by default and should rather be installed in the actual qube instead of the template. See also this thread.
This might be of interest to you: