I didn't like the "explanation".
What I am missing is the real explanation why the sub query in the EXISTS doesn't result in an error.
It actually matters what is in that sub query. For example:
SELECT 'Test' WHERE EXISTS (SELECT 1 WHERE 1 = 0)
will not return anything.