I think one of the main niches CB Linoone has is being able to provide an offensive team with a very strong revenge killer (and priority user) which can also sweep a weakened team. It is not meant to break down walls like Belly Drum can, but it can certainly still sweep. It also provides extra insurance against many weather sweepers, being able to bring them down with a bit of hazard support / prior damage.
Not to mention it provides a very good option to revenge kill frail threats like Zangoose, Cinccino, and Swellow. I'll state this again, its not meant to break through walls or pivots (even though it can on some occaisions) it's meant to be a revenge killer and late game sweeper.
Against more defensive teams it can use CB Return, which will not be breaking through full stall teams with max / max Amoonguss, Alomomola and Regirock certainly, but can still do a decent chunk to other common walls like Musharna and Miltank.