I've found that achieving goals where nothing changes can be pretty anti-climactic. An example is weight loss, where you reach a normal weight or whatever goal you have and afterward, either you keep doing what you were doing or you'll gain weight (unless you do something else that changes calories in vs. calories out).
Taking a break from goals is also a judgment call and not necessarily something to be ashamed of the way motivational YouTube videos will say.
It's up to you what you want to do with your life. If you set a goal but wind up giving up on it, hopefully you can still learn something from the experience. Beating yourself up or telling yourself you are a "quitter" or a "failure" does not help.
Motivational books and videos will basically idolize being a perfect robot that never relaxes, never takes time off or does anything relaxing, and in many cases neglects basic things like spending time with family, sleep, etc. I think that's unrealistic. I need something sustainable if I'm going to make a lasting change in life. But that's just me.
I think the whole "be-the-hardest-worker-in-the-room" holds good only when you're so into your work that you forget what time it is. Otherwise, it definitely becomes a chore and a health hazard.