It certainly does not need to be painful. I think most people will make a distinction between the burn of acidosis, or what you call unease, and actual pain indicating damage is occurring.

But yes, if you never train close to failure you will not grow, not past beginner gains, unless you take steroids.