Only time will tell.
When FDR introduced Social Security back in the 1930s many people were completely against it. Today it's a "sacred cow". Millions of senior citizens would be in dire straights if it did not exist. The same could be said of other government programs such as Medicaid and Medicare.
In all honesty both political parties see that with the 'Baby Boomers' approaching senior citizen age some major change is needed in the healthcare industry. Medical costs are among the top three reasons for filing bankruptcy in the nation. Even president George W. Bush introduced a prescription program. It too was also delayed when it was rolled out.
When you couple that with millions of people who don't have any insurance that really drains the nation financially. Something had to be done.
America is one of few industrialized countries which did not have some form of a national healthcare system. Countries in Europe are surprised this is such a hot issue in the U.S. "Obamacare" is not even a national healthcare system. Most people will continue to get their insurance through their employer and not via government exchanges.
Lastly I believe people have more of a problem with the "messenger" than they do with the actual components within the law. Is anyone really against not being denied insurance because they have a pre-existing illness? If you have a child in their early 20s without insurance wouldn't you like to have the option to add them to yours? No annual or lifetime limits on healthcare, New preventative Services at no-out-of pocket costs....etc
If you took a survey asking people if they'd be in favor of each of these benefits without calling it Obamacare or the Affordable Healthcare Act the vast majority of people would welcome these changes.
We'll have a better idea of how good this is for the country in about 10-20 years. I suspect 50 years from now it will be viewed the same way Social Security and Medicare are today as things people don't want to do without. It nonetheless will be tweaked over the years.