(Self employed are in a complicated way in between)
Not that long; IIRC, the vast majority of the money made for most artistic works is received within the first decade after creation; the share of artistic works returning much after that compared to before is small.
Sure, the works you’ve heard of are often exceptions to this, but that's because you are vastly more likely to be aware of things way out in the successful tail end of the distribution.
While for some it is the long tail which makes it viable.
Even ignoring inheritance this is wrong, because you can sell it to someone who might outlive you, and spend the proceeds while you're still alive. The amount you can sell it for is going to be much less if there is substantial risk that the property goes away soon after the sale.