I'm in the same scenario, I've been a season ticket holder since the mid 80's, my Son who's 32 has had one since he was 5. He's never seen us win anything. His mate, who's a great lad, buys a membership & attends a handful of games, gets the same chance & the good fortune of being picked. Our biggest game in 42 years & we won't be there. That is wrong, no matter how you look at it.
I'm fortunate that I could afford to pay the 30 times face value the resale sites are asking for a ticket. But it's immoral & I won't do it out of principle. UEFA & our own club has fucked us over & it's going to take a while for me to forget that.