It will definitely not be a walk in the park, but the newest ships and landers as well as the tech is so much more than I had on the USS Ohio. The longest we went underwater was 3 months. It definitely wears on you, but you work so much that exhaustion keeps you from any serious cabin fever. This is also helped along by the fact that we keep the oxygen percentage on the sub a little lower than surface air to lower the risk of fires.
To me, the biggest challenge won't be comfort, necessarily, but zero Gs and being able to hold off the deterioration of the body in hypotension. Humans can live in some pretty shitty conditions and space will necessitate them for now, but having the best view money can buy probably helps morale some.
I think that humanity is on the cusp of its next big jump into a new era. The old ways of doing things are no longer working, and new paths to the future will have to be charted. We are still very much in the veery early days of space colonization, kind of like the build up to the mercury program back in the 50s.
Tech is advancing so rapidly that even at 30, I've seen some technology I couldn't even dream of being real is now just in everyday use, so I remain hopeful about humans in space. Our drive to discover is so ingrained in to what we are that I see it as inevitable (if we don't destroy ourselves first) It is a compulsion that spread our species to the farthest reaches of our world and I have no reason to believe our world would be the last boundary.