Yup, those HIPPA waiver forms are typical. Basically they serve 2 purposes, 1) the waiver is to inform you of your rights under HIPPA, and 2) the waiver authorizes the medical provider to release just enough information about your health care to the insurance company so that they can get paid. Health care providers and health insurance companies are held to strict privacy standards under HIPPA; so your waiver allows them to communicate with each other, but does not allow for either to communicate with the employer that pays the insurance premiums.
I don't know about the case you mentioned where the CEO shoots off his mouth, but I've worked in enough office environments to know that office workers tend to know each others business that way because people talk. The parent of the baby spoke to someone else in the office who spoke to someone else who spoke to someone else, next thing people are pooling money to send flowers, etc., etc. I sincerely doubt that the CEO got his information via the company's insurance carrier. It just doesn't happen.
As long as your partner doesn't talk about your medical procedures with co-workers around the water cooler, your surgeries and procedures will remain your own private business.