You don't have to keep Sims happy, but it's highly beneficial:
While not required to finish the game, happiness makes the experience richer and more rewarding.