Will we travel to Mars?

According to Elon Musk, we could soon be living on Mars. Yet, this idea seems unrealistic: extreme cold, an atmosphere composed primarily of CO2, and dangerous cosmic rays... So why on earth would anyone want to settle there? Where does this enthusiasm for the Red Planet come from?