As long as you remain static and don't change at all from the point you get the tattoo until your death, yes. If your thoughts/ideas/preferences might ever change from that point on then no, it would be a waste of money.
I understand where this view comes from, but my experience leads me to disagree.
I got my first tattoo 15 years ago. I was 21, a child in many respects. I was single, living in a tiny apartment, working building houses for $10/hr, drove a VW bug I got for $500, and thought I was going to be a writer. Main priorities were drinking, writing, and riding my bike.
15 years later, I'm married, have two little kids, work as an engineer, own a house, and am starting a business. My main priorities are raising awesome kids, being in love with my wife, and living a full existence. I am a VERY different man than when I was 21.
Guess what? I love that tattoo. Its awesome. I drew it in one of my journals, its tiny, and cost $50. When I look at it today, it gives me the same feeling it did all those years ago. Its rad.
My view is that if you would like a tattoo, you are being thoughtful about it, and its financially reasonable, then there is no rational argument against it. There a lots of opinions against it, but none that hold water when looked at practically. Its your life, do as you like.
As far as tattoos being financially reasonable, here's my take:
I have 12 tattoos. I have spent $1300 on them in the last 15 years. Say I didn't spend that money and instead invested it. So, I spread the investments out over the last 15 years, assume a reasonable 6% interest, and I would have to invest ~$2400 right now to to equal the same return by the time I'm 75. My current hourly rate for my side gig is $150/hr. I work two full days and I have paid for this frivolity. So, have they been worth two days of work?
Yep.
To me, there is a kind of Mustachian credo that can be arrived at here:
If you are
mindful about your choices for fun/entertainment, they
don't harm the earth or others, and they are
reasonable financially, then go for it.
We don't have agree with others' choices for fun. They should not be having that fun for anyone but themselves. Live and let live.