I hope so, and if I'm ever in need of a webpage design, I'd love to hire that same designer.
Seriously, the site is close to perfect. It looks nice enough, it's clean, fast and full of content - instead of being full of useless eye candy and short on actual information.
Fancy is good, fast is better.
It's expected of them to have a better looking website.
Please remember that this is all volunteers. I'm pretty much sure Postgres community would love if you help them on this.
If they didn't care for design, then they should have stuck with the old look, like http://sqlite.org or http://www.berkshirehathaway.com/. Both are perfect examples of "we know exactly what we want to be and we don't need to worry about design".
But a half-baked result that pretends to be finished, suggests a lack of confidence in the software that it champions. Which is, frankly, unbecoming.
Before people say "OSS must look bad" or "It's a minimal style", I encourage looking at https://www.djangoproject.com/. Aesthetically pleasing without sacrificing clarity, this website sets the standard for a technical project's homepage redesign.
Boring and half-hearted UI's should be relegated to the likes of https://www.oracle.com/database/index.html than to a lauded and respected database like Postgres.