I suppose you have to give up some features, but given how few of the features on most apps I do use, I think this could be an acceptable tradeoff.
I'm actually pretty stoked for this to be honest! Can you imagine if there was the possibility of switching those profiles in real-time, like an upgraded version of the "battery saver" that already exists.
That being said, I love having a choice. A lot of people criticize apps being split up, like Allo/Duo, but I like it. I don't get the obsession with all-in-one apps. Youtube's strategy of splitting out Youtube Kids, Youtube Gaming, Youtube Music, etc makes so much more sense.
Some might want the heavy Youtube, some may want the light Youtube Go. You get to choose what your needs are. If you don't need all the extra crap, download the Go version!
It's sad, because I wanted Android One, now I would like Android Go. However I fear that it will be "unavailable in your country".