Yes, it is very very interesting, but not ALL the time!
You do not make important discoveries every day, or every year, but I have always found the process of discovery extremely enjoyable. Working with data you have acquired at an observatory, or from a satellite, and then manipulating it in various mathematical ways to bring out the story it has to tell, is detective work of the highest caliber. You are the only one to have ever done what you are doing, and you are pioneering the way with no one to tell you how to do it. The excitement of being the first person ever to have tried a particular approach, and then to actually uncover something important from it, is a captivating experience. I have never experienced dread about coming to work in the morning and having a complex set of activities before me to accomplish. I do regret, however, that my work is so solitary. To sit in your office all day working on a paper you are writing, or manipulating data, or formatting figures and tables for analysis, is pretty lonely.
The other thing that makes my 'job' interesting is the opportunity I have in a popular field like astronomy, to help other people understand it better. More often than not, I gain far more enjoyment in the teaching of astronomy, than in the doing of astronomy. My profession will continue to evolve and develop without me, but when I help someone else understand some question or idea in astronomy just a little bit better, I feel like I have truly made a lasting contribution to humanity. Isn't it odd how it true satisfaction always seems to come from helping others?