It has definitely happened in the past, but in practice it’s a very small percentage of titles that are fully removed from your account beyond delisting.
It’s a risk many people may be willing to take especially with low value purchases.
This is weighed against the costs and inconveniences of keeping physical disks or self-hosting infrastructure running.