Listen to an equal amount of the opposing POV that still enjoy the job after 40 years. No, just like sex, it's not as exciting as it was the first time. But most people still enjoy sex after decades and decades. "What? You want to put what where? I've done that thousands of times and it's not worth it.... says almost no one.
Ask the naysayers what they'd be doing instead? Ask yourself - what are the odds of that happening? How long does their alternative take to happen? At one point I thought being a surgeon would be interesting. Now I'm glad I never had to do that as, at least to me, flying is more interesting. I've talked with my surgeons and my surgeries were 'ho hum' to them. "Any professional interest in the surgery?" "Not really." Maybe life saving to me but 'another day, another dollar' to them after 10-15 years of surgery. They had 20+ years to go to retirement....
Learn to fly and figure out if it really interests you.