This is going to vary from case to case.
In a situation where sales are legal and the publisher or platform later choose to remove it from sale then it usually remains available in your library for download.
But in a situation where the publisher never had a legal right to sell the product then they were never legally able to grant distribution rights to the platform? In that case the license offered to the purchaser is invalid and it may be pulled from libraries.
The future is indeed dumb. The 2022 GoldenEye has it’s own baggage.
I don’t think Nintendo was willing to let Microsoft sell it as a physical product (collectors would view it as superior to Nintendo’s NSO requirement).