The Uncomfortable Conversations with a Black Man author will take over for Chris Harrison on After the Final Rose