Our youngest DS (30) did get tired of WDW and doesn't like it much any more. We went every 3 years when he was growing up, and as an adult, he finds his adventures elsewhere. His latest vacation of choice was 2 months backpacking through southeast Asia, Laos, Cambodia, Thailand.
He and his DGF came to our 40th Anniversary party last month at VB and VWL, but they enjoyed VB much more than WDW, in fact they "missed" the only all group get together there, dinner at 1900 Park Fare. We thought having DGF along would "help" his attitude, but I don't think she liked it any more than he did.
Our oldest DS and his family loves going to WDW as much as DH and I do, so we've bought more points than DH and I could use ourselves, we're empty nesters.
So, getting tired of WDW is a possibility, but so is selling the DVC points when that happens.
Bobbi