The EU Wants Its Own DNS Resolver That Can Block ‘Unlawful’ Traffic

An interesting quirk of the EU is that anything done requires consensus of 27 countries. So you end up with either systems where everyone gets free reign to demand what they want, or some that implement commonly agreed standards. In this case unlikely this they'd let Poland or Hungary decide on their own what is accessible for all, so you'd very likely end up with a list of standards that is transparent and actually presents a check on national censorship powers.

My thoughts exactly, who is the target audience here?

It can't be technical people, they'll just use whatever is fastest or selfhost. It can't be the average consumer, they don't what DNS is or why they should use one provider over another. Perhaps ISPs to ease the burden of being compliant with blocking sites?