Just because your house is a liability (not an asset) doesn't mean it isn't very useful or necessary. No doubt, you need a place to live. You also need food, water, electricty, etc. but you likely don't consider them assets right?
I suspect folks get confused because the home builders, realtors, and mortgage vendors have done a good job of convincing us that our houses are an asset/investment over the years. But this is more advertising than reality.
I also think people get confused because owning a home dramatically reduces the amount that you end up spending on the place that you live. (Especially once the mortgage is paid off!) A penny saved is a penny earned after all, so this makes home ownership look suspiciously like an income increase.
You mentioned turning your home into a cash-flowing asset. I'm not 100% sure how you do this. I'm guessing you move out and rent the home out to someone else? In that case, you still have to have (and pay for) a place to live. All you've done is move the expense entry for that place to live to another address.
Over the long term, house prices tend to follow inflation. So we can imagine buying a home for $300k in our 20's, living until we're 80, and having our heirs inherit and sell the home for $600k. Viola we have a $300k gain on our "investment" right? Not really, our heirs will discover that $600k buys them a home comparable to the one they are selling. The same inflation that increased the value of our home, also decreased the buying power of the dollars our heirs get when we sell the home. So, not an investment right? (Or at least a pretty crummy one.)