Is Happy no foam a long term solution for spa water foaming?

No, It will simply eliminate the foam in the short term, but in the long term, fixing the cause by showering before hot tub use is the best way to prevent it. For a product that oxidises (burns off) whatever is causing the foaming, check out Happy Non Chlorine Shock.