It's still horrible advice. There is no such thing as universally good advice. Everything must be taken in context, and saying/accepting "no" is often the best path.
You're right. Blindly following an advice taken literally is never a good idea. However as a general mindset I think it's really valuable tip for many people who unnecessarily limit themselves.