Done right at your home, it could be.
I’ve become interested in hydroponics with a fish population mixed in. It’s interesting.
If it was studied enough, I think there’s the likelihood you could get an eco system going that would be clean and nearly self-sustaining.
A guy right around the corner from my house is doing, and has been doing EXACTLY that for probably a couple of decades, at least!
He’s a really old guy, says he’s 100, but looks no more than 70 or so.
He’s married to an Asian woman, and she doesn’t look all that old, either.
His whole back yard is on huge garden and fish farm. This is in a residential neighborhood, not some rural farm setting.
He has all kinds of weird vegetables and vines growing on and around everything. He has a bunch of barrels/drums connected together with pipes, maybe 20 or so. In the tanks are live fish and there are several types of aquatic plants growing in and out of them as well.
All he has to do is keep the water flowing and aerated. The fish eat the plants and food pellets he tosses in everyday.
For a meal, all he has to do is catch a couple of fish, some are a foot long or longer, wander around the yard picking fresh veggies of various kinds and his wife cooks them!...............