Personally speaking, I was surprised to see (particularly on Facebook) such a positive reaction to the announcement. We've had this before on at least 2 occasions, that there are plans for a new stadium but they just never get any further than the drawing board. Call me a cynic, but it just ain't gonna happen this time either.
SISU from the start have always wanted the Ricoh, I don't think anything had changed in that respect. We're too long gone with them to come up with any sort of fair deal for both CCFC and Wasps to properly share the stadium unless SISU publicly admit to and renounce all past sins, and then promise a fair way to jointly own and run the stadium for the benefit of both clubs. That would surely be the best way out of this (other than a takeover and for new owners to shake hands with Wasps' owners on a deal).
I'm not a big fan of the Ricoh, but it's there, it's in our city, it's purpose built for our football club, it's still got our name written into the stands, and to ignore it is plain stupid. As a few people have said, get a team playing good football onto the pitch week in week out and the fans will come and make noise, the whole atmosphere argument will quickly go away. Imagine if we'd played there last season, we'd have been getting crowds of 20k+ and I can't imagine we'd have been complaining about the atmosphere then.