Clicking “Hide on Profile” means neither you nor anyone else (except for perhaps administrative people), will be able to see that question or answer on your profile Overview. However, you and only you (except as mentioned before), can still see them in your Questions and Responses tabs.
Clicking “Show on Profile” means any questions or answers that were hidden, are now publicly visible on your profile Overview and in the aforementioned tabs.