That's not what it says. You've fabricated the part about letting the copyright expire.
From that page:
> If, upon viewing a work, you see words such as, “This work is dedicated to the public domain,” then it is free for you to use. Sometimes an author deliberately chooses not to protect a work and dedicates the work to the public.
And I did not fabricate it. It was directly from your link, without so much as scrolling. They have a 4 point list of ways for things to be in the public domain (and it's bad... like "wasn't renewed" is identical to "letting copyright expire", just because the law previously allowed renewal doesn't make that a special category).
> Sometimes an author deliberately chooses not to protect a work
Which isn't public domain. It's something else entirely.
When a work is in the public domain, the author can't choose to protect it. Only the government can do this, and they made no provision for authors to choose to put works in the public domain.
If the author can change his mind (or his descendants), then it is not and never was in the public domain. It is an important distinction, one which failure to understand it has the potential to cause grief.
This time from Cornell Law:
> Once that period of time expires, or if the creator failed to comply with any legal formalities required at the time of creation or thereafter, the work enters the public domain - meaning it belongs to everyone, without restriction. The creator may also decide before the expiration of copyright to dedicate the work to the public domain, giving that new creation to the public to use.
https://guides.library.cornell.edu/copyright/publicdomain
The author cannot 'change their mind' in this case: the rights, once given up, cannot be reinstated.
There is a sharp edge here with collections of public domain works being copyrightable, but that's a separate issue, and does not affect the public domain status of the contituent works.
1. The copyright expires.
2. The copyright expires because it wasn't renewed.
3. They dedicate it to the public domain, and then wait for the copyright to expire.
4. Was never eligible for copyright.
So, SQLite's almost got it done... they just have to wait the better part of a century, and their quest to put it into the public domain will have succeeded.