It's very hard to justify that something is "frivolous" or "non-productive" when it contributes materially to the happiness of a lot of people. People can deeply enjoy football, it can strengthen family and community bonds or just make for a fun evening. We don't live in a bleak dystopian society where we do nothing all day but provide for each other's physical needs. Football is no more frivolous or non-productive than easily most of the economy.
And actually, movies and professional sports have advanced our understanding and technology a great deal, be it by advancing camera and computer imaging technologies or by advancing our medical knowledge by giving us more experience dealing with certain types of injuries. The competitive nature of professional sports also gives us insights into the most effective ways to train, condition, and give nutrition to the human body.
I don't think they're on the same order of magnitude in terms of knowledge gained - those are mature industries, space travel isn't anywhere near, so the gains should be much more dramatic and broadly applicable.