You're going to have to compromise a lot. The trail you've shown is generally best suited to wider knobby tires, which are inherently slower on the road. Also, light weight and hauling grociers is again a bit of a contradiction.

You might consider the class of "gravel" bikes. A true CX bike has a bit more aggressive geometry than you probably want. Gravel bikes are typically more like a drop-bar mountain bike.

It sounds like you really two bikes. A fast road bike setup for light touring, and a beater mountain bike that you can use for trails and winter.