I think there are a lot of turntables that you could reasonably expect to last 25+ years. The bigger question is if the companies and parts remain around that long if it's needed. For example, my Ultradeck is ultimately a very simple machine. With minor upkeep, primary lubrication, I fully expect it would easily last that long. The parts I expect to wear out would be the belt, the O ring on the headshell mount, and possibly the motor. But as long as all those parts are available, It should easily last decades.
Now moving into designs like Linn and VPI, those should last WELL beyond 25 years. The companies are well established, and the tables are built in a manor that nearly every piece can be replaced or upgraded. Simple belt drive designs with high quality metals, and easy motor replacements. I would expect these table to easily last over 25 years without issue.
Now if you're looking at something like cheap direct drive tables like the LP120, I wouldn't expect that to last 25 years. It should last awhile, but once the electrical components and motor start to wear, it would likely cost more to fix than just replace the table.
I don't blame anyone for wanting to take a break from vinyl. Or from audio overall honestly. It can come in go in waves. A good CD player and DAC can be very satisfying, and I keep both in my system. I have several albums on both CD and vinyl, as well the ability to stream. Sometimes it's fun to compare the various formats, and it gives you the option to find which format actually received the best mastering (it's not always vinyl).
Have fun with it!