Pike is the captain Discovery needed to restore order and faith to the crew after Lorca, I totally agree. But the craziness of DISCO, the way it takes risks in its casting, story-telling, structure etc. is what makes it unique to me and I'm currently enjoying the journey the show taking us on. So I'm not sure I want Pike to continue on next season, especially since he has the Enterprise to return to.
I'm just wondering whether I'd enjoy all that much a more 'traditional' spin off (with Pike as the focus) which attempted to appeal to the fans who want to return to the old school Trek they are more comfortable with and fond of. Maybe I would. But, for now, I prefer the 'new and different' approach. I've never been a big fan of tradition or continuing the status quo, so I guess that's why the idea is less enticing to me.