I’ve even found “Is not null” queries on a Boolean column to be slow so I made a generated column that’s Boolean.
Did you try a filtered index using WHERE ... IS NOT NULL instead?
Or maybe an index on an expression coalesce(the_column, false) and then use that expression the where clause?