The unpopular individual mandate that's part of Obamacare was unnecessary to the program's overall success, and it's going to hurt Democrats in next year's midterm elections, former Democratic National Committee Chairman Howard Dean tells CNBC.