Something does not need to generate a positive cashflow to be an asset. An asset is a store of value. A house is one of the most common stores of generational wealth. Pretty much the only think my parents left me when they died was my share of the family home.

A large fraction of homeowners do sell their homes and downsize or move to retirement community/nursing homes near the end of their lives. They often use the proceeds of that sale as retirement income.