Yes.
If the charging unit redirects from the archers detachment Into the spear regimental unit, they can only hold or flee.
If the hold, the handgunners detachment is not engaged in combat or fleeing so can declare a supporting action.
However, if I was charging the archers and they fled, I would redirect into the handgunners