We used to live in that area. Very quiet back then. Black Mtn Rd ends near there so traffic was minimal. However with Carmel Valley Rd now open to 4S Ranch, traffic could be a lot different.
Backing up to a noisy road will always impact your resale value. We would never live in a house backed up to a noisy road. Been there, done that. But if you’re getting a good deal and the noise doesn’t bother you, no big deal. When you want to sell, you’ll just pass on that good deal to the next buyer.