Showtime's place as the adult brand in ViacomCBS' streaming strategy has some people close to the network questioning its future.