Judging only by our own limited known experiences, & weighting that higher than all the people who do use & enjoy a thing is... not good.
I agree that Web Push has a lot of really bad uses, is terrible on almost all sites. But it also means folks using ProtonMail or other email systems[1], or folks on chat platforms, can function when all they have is a random web browser on a random computer in front of them.
Ultimately I lay much of the blame here on how permissions & user-gestures were iterated forwards, thinking it was going to reduce nagging on websites. User-gestures failed to accomplish the desired results, are a failure, haven't fixed how annoying permissions are on the web, & we need some new approaches. Web Push is perhaps the headlining feature that makes the problem most obvious, because the ratio of places we'd want it to places that have it is tiny. But that doesn't change my base feeling, which is that this is a vital & core capability, and our personal apathy towards it's presence shouldn't prevent us from appreciating how great it is for some.