Jamie,
It’s great that your son loves science and enjoys learning! His dislike for any books not creation based will make it more difficult to find many books.
Some options to consider:
Wonders of Creation series from Master Books. Each title in the series is focused on one science topic, such as weather or geology.
The Stargazer’s Guide to the Night Sky by Jason Lisle.
Eric Sloane’s Weather Book. This is an older book with some out-of-date material, but it is a good introduction to how weather works.
The Way Things Work by David Macaulay. This one is not creation based, but that shouldn’t matter because it is focused on physical science. Also, there are several editions of this book out there, all with similar titles. The original title is The Way Things Work; revised and updated editions are titled with a variation of that, such as The New Way Things Work.
Anyone else have any suggestions?