"I don’t love what that looks like as far as an endorsement, given other things that’s he’s publicly stated about his beliefs," Urban's collaborator tells Nashville Now podcast