I personally think that air mattresses are more comfortable than beds, assuming you have your own. I absolutely hate sharing a air mattress with DH! Unless both people are exact equal weights, one person rolls toward the other.
Air conditioning would also be a necessity in June. We use a regular window air conditioner on a couple of cinder blocks and just zip the door around it. There are much fancier ways of doing that. They make something called an AC Boot (I think) that you can install in your tent to accommodate a window AC.
The third issue is how old is your DD? If she is young, are you anxiety prone? That was always a big issue camping when my kids were young. I didn't sleep well because I was worried about them in a tent.
So, while I would stay in a tent for two weeks, my conditions would be:
1) My own air mattress
2) air conditioner
3) child old enough to not wander off
As far as that two weeks being at Disney.... not 100% sure about that. For me, at 49, Disney is very exhausting. I am so sore and tired at the end of the day that I'm not sure I would be up to the rigors of tent camping, especially after a couple of days. But, like someone else said, if it was camping or nothing ... tent here we come!
Two suggestions -
*Check into the prices at value resorts and even offsite places. I know costs at the Fort have gotten high and you may not be saving that much money. Rodeway Inn, although not the best reviews, not the worst either is only approximately $30 a night.
*If you do end up camping, alternate park days with pool days. Two weeks is enough time to give you the luxury of doing that. Along with the pool, there are many other things to do at the Fort that make for a more relaxing day than parks.
Good luck whatever you decide.
