No.
You should not have any cavities between your thermal planes (consider the manufacturing requirements for eliminating humidity in the fabrication of insulated glass units).
Likewise, it is critical that you do not provide means of airflow.
Airflow will provide thermal bridging, 'short circuiting' your insulation.
Airflow will cause degradation of your building materials, mold and so on.
That is, natural convection will pull warm air into the cold cavity and spill the cold air into your conditioned space, not only will this fail to reduce your energy costs to their full potential for a given insulation value, but also it will cause the humidity in the warm air to precipitate on the cold surfaces of your thermal plane(during the cold seasons; and vice versa in the hot seasons). This can be gallons of water and is a common problem with basement weatherization improvements.
As for what do you do about water damage (be it from appliance failure, burst pipes, ground water pressure, flooding spilling over the foundation, or whatever), you will need to determine whether your conditions ensure reasonable certainty of the success or failure of your project. First, you'll need to determine if any of these are known, unpreventable, recurring issues with your specific home site. Next, you'll need ensure you have the means to protect your investment (preventative maintenance) and insure it against unforeseeable-unpreventable damage events to the portion of the replacement cost you are comfortable with and/or financial capable of covering (Homeowner coverage against the particular water damage types you are concerned about; partial or full replacement cost and in either event you'll either need to and then you need to catalog the actual cost, down the the individual screws - no joke - or you'll have to pay someone to do that work for you after the fact if and when the damage occurs). (A note on flood insurance, some types of flood insurance, especially FEMA backed flood insurance, are notorious for never getting paid out even with a solid claim).
The products you've listed all require a means of capturing moisture and expelling it. Often times that's a perimeter trench cut into your basement slab, channeled to a sump pump. This is critical for flooring applications for several technical reasons - for example, if you don't get the water out, it can will literally float your flooring as ground water pressure
of percolates up through the slab.
Closed cell foam is the only appropriate material for your project (unless you want to go nuts and get into using an exterior rated waterproofing system inside your foundation, which would be hilarious).