Yeah I think the pull based is not that common (usually for standing orders, and most of the time it's intra-country, through it works cross) but the push mode is also very popular
Having recently-ish moved to Spain, I think both push and pull are fairly common. Both my health insurance premiums and phone/ISP bills are just taken from my account each month.
Sometimes larger transaction (buying a mattress for example) seem to SEPA push based, but I don’t do a lot of one off transfers (using SEPA).
It does seem like Bizum has taken over for person to person transactions, though. Even some companies are accepting Bizum for online payments, and I’ve seen some small shops posting a QR code for their Bizum at the checkout counter.