Did Jake Sisko ever wear this remarkably ugly sweater on screen, or was it just for a this photoshoot?
He really did wear it.
Jake wore it in the Season 4 episode "Shattered Mirror", where Jake and his father are captured and taken to the Mirror Universe.
Here is a screenshot of Jake wearing the sartorially-challenged garment:
(The woman with him is the Mirror Universe version of his mother.)