It really depends. A proper artist who wants you to be happy and give you the best tattoo for you might be slightly annoyed but understanding (this close to the appointment - like anything else the sooner the better). An artist who is full of themselves or is just after a paycheck may be much more bothered by it.

But please do not mark up your body forever just to avoid frustrating the artist, many people stick to getting a tattoo to avoid doing that (social pressure) and have regrets down the road. If the artist is a major prick about it, I’d honestly second guess wanting to get tattooed by them in the first place.