If you prepare your tent and awnings correctly, rain shouldn't be a downside of tent camping.
Make sure all the seams on your tent are sealed thoroughly and you coat the rainfly/exterior fabric well with a water repellent such as Scotchguard (there are other brands in camping sections of stores).
Also have some type of shelter like a dining fly or screen house outside your tent just over the entrance. That way you are under shelter as you leave the entrance of your tent and you can leave rain gear/wet shoes, etc. outside your tent hanging from the interior of the dining fly and leave wet shoes in a plastic shoe box outside the tent.
Also you can set chairs under this shelter and sit outside even when it's raining. You are not stuck in the tent during rain.
Make sure you have three layers of groundcloth for your tent.
Layer 1 - Inexpensive painters plastic directly on the sand bed at the site. (This is thrown away at the end of the trip. This just keeps the bottom of your tent and your groundcloth clean for packing up.)
Layer 2 - At least 6 mil plastic sheeting cut to 1" smaller than your tent on top of the painters plastic
Set the tent up on top of that.
Layer 3 - At least 6 mil plastic sheeting cut to the interior dimensions of your tent and laid inside the floor of your tent. This provides another layer incase some water does seep up from the floor and also protects the floor of your tent from holes caused by walking in it, the feet of cots, etc.
For sleeping comfortably, I recommend an air mattress at least. There are also cots that fold up with an air mattress on top. There are also cots with mattresses.
Sheets, pillow, and blankets, then maybe a sleeping bag if you need a little more warmth.
Do bring a fan and a 40' outdoor extension cord. Even if you don't need the fan at night, you need to run it during the day while you are out and open the windows for ventilation to combat the humidity.
Also leave the windows at least unzipped a little bit at night to avoid condensation from all that moisture humans create.
I hope this helps!!
Carol