Nope, spam censoring pools are in a minority. Fee revenue is low now because the blocks are empty, but it can be significant source of revenue for the miners, check may 2023 at the peak of spam activity.

Some blocks had more in fees than coin subsidy and miners happily mined spam to collect the fees. It would be irresponsible for revenue not to.

In a way, spam solves the security budget problem :)