Stay in academia or become professor without overworking, is it possible?
This is a bit opinion-based, but I'll offer my own personal take on an answer in the hopes that it might be useful; at least parts of what I wrote below seem pretty generally applicable to me.


  Is it possible to survive/remain in academia by working normal hours (8-9 hours per day) without working evenings, weekends, holidays, without feeling guilty about taking a 2-3 weeks vacation?


Short answer: no (except for the part about feeling guilty for taking a vacation, which is something I never had a problem with).



Medium-length answer: this question is based on a false premise, and simply doesn't make sense to most professors. "No" is an approximate answer, but a full answer requires a longer discussion to explain why neither "no" nor "yes" really make sense as answers, and why even though "no" is an approximate answer, it doesn't really have the negative meaning that you think it has.



Long answer: people in academia do work hard, sometimes very hard, but in my experience, the thing that many people looking into academia from the outside often fail to see is that what you call "working", we call "living" (and what you call "overworking" we might call "living a bit more intensely than usual, but still generally having a good time"). What you call "making sacrifices" we call "finding our work so fulfilling that we pay less attention to some other aspects of life than most other people do".

In other words, for a professor the "work/life" dichotomy is a lot more blurry than it is for people in (some) other professions, to the extent that it is often a completely nonexistent or nonsensical distinction. If I'm at the beach on a weekend and I'm reading a math paper or thinking about a research problem, am I doing "work"? If I'm traveling to a conference in an exotic city and using some of the time to explore the local sights and culture, am I "working", or am I on "vacation"? I don't know, and honestly after doing this for a while you start to realize that these questions simply make no sense. Most professors simply don't make the distinction between "life" and "work" that much of our culture obsesses about. They don't ask themselves these questions about how to "survive in academia" while only "working normal hours", since most of the time they are just too busy doing something they enjoy. Yes, they probably do end up doing what other people would regard as "work" for more than the usual 8-9 hours a day, five days a week and during times (holidays and weekends) when other people might regard it as abhorrent to do "work". But by and large, they don't perceive this as a negative thing (or at least, not as negatively as your question makes it out to be; I'll admit it can be a mild annoyance at times).

Coming back to my short, approximate answer of "no": basically it seems to me that you're asking the wrong question. If you are the kind of person who really wants to punch in at 9 a.m., punch out at 5 p.m. every weekday and go home to do other things and not even think about work until the next day, I'm pretty confident that academia is not for you. But most people who are smart enough to make it in academia are not wired that way.* The real question you should be asking is "can I be in academia and have a fulfilled life in which I'm happy to get out of bed each morning, get to do really exciting stuff a large chunk of the time, and in which I work hard (sometimes very hard) but still have a reasonable amount of time left over for other things that matter to me?" 

The answer to that question is, quite definitely, Yes.

* (Added on edit:) to clarify, with this comment I am not expressing an opinion that a decision to leave academia says anything about how smart (or how anything else) someone is. I most certainly do not hold such an opinion. See the discussion in the comments.

———

Second edit: The comments, along with a few negative votes on my answer, are making me strongly suspect that I’ve given offense to some people who are perceiving my “smart enough ... not wired that way” comment as an elitist sentiment to the effect that if you are a person who is “wired that way” — that is, cares about having free time, work-life balance, raising a family etc — then you are “not smart enough”. Let me emphasize again that that’s not what I believe and not what I meant to imply. I actually care about all of those things myself, and don’t think caring about them is inconsistent with working hard (even sometimes very hard) or with being very passionate about your work. Nor do I think academia is the only place where one can have a fulfilled career; there are in fact many workplaces and professions with quite similar characteristics, and obviously there are many extremely smart people pursuing careers in such places and professions.

Finally, as I said at the beginning of my answer, it represents my own opinion and my own personal take on OP’s question. I make no claims that this represents anything near a universal truth.