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.