@rek In the Puget Sound region at least, ports have quotas for liveaboards that have been topped out for a decade. Three years ago the waiting period was 3-5 years, today there aren't even waiting lists, the answer is just, "no."
None of the fiberglass heaps around here will get a second wind as floating apartments, for better or worse. They're just toxic tea bags floating in the water.
@humulus lack of foresight is a common culprit. Boat builders ought to have paid in part for future boat-breaking and recycling(you put a thing that cant biodegrade in the world, that ought to have a cost), and to maybe have a recycling fee added to the sale of a brand new boat.
Anyway, wishing for it wont make it happen. We're too many years into this. Feds would have to step in, but if they do they'll do it in a way only benefitting moneyed ppl.