Didn't you see the news reports about Lemmy's funeral and who attended, or the news websites providing full-length video of Dave Grohl's eulogy? I'm sure much of that attention, just like with Bowie, is from people who have little or no appreciation for the man (which I don't have either - I know, and don't even particularly like, precisely one song by him). But it was still a plenty big deal in the media, if not as big as Bowie a bit later.
Lemmy's influence and status was more limited to a specific scene than Bowie whose influence and connections extended to a wide spectrum of musicians, and well beyond that into cinema, fine arts, contemporary dance etc.
But Lemmy was some kind of god to the hard rock and metal community, fans and musicians alike. Not only that, but before Motorhead Lemmy for a while was in the seminal/legendary space rock/psych band Heldon (not as famous as Pink Floyd became, but it's another of those bands that have a greater reputation among musicians themselves than in the general public).