You can get a cargo bike with a rack on the back or a tub in the front. My ebike can hold over 150lbs on the back and I took it grocery shopping back before I lived in walking distance of grocery stores

If you exclude work and food, what's the remaining usage of a bike? leisure?

I've been 100% bike for all my adult life 20 years long, half of it commuting, half remote work, groceries up to 20kg (I carry crates on my handlebar), rain is annoying, but it's like people on motorbike, with proper clothes it's fine, but it's indeed less easy than a personal car. but not so much about natural elements, more because the cities are built for cars

You can put groceries in an Organic Transit ELF or a BetterBikes PEBL. These are enclosed, recumbent, tadpole trikes with room for the driver along with two small children, one adult, or groceries.