This masjid is good for non-muslims. Please respect the clothing rules while visiting the masjid. While the whole of Dubai might be liberal. It is expected to wear modest clothes while visiting the masjid as a mark of respect.
For Muslims, there are better masajid in Sharjah. Or the Sheikh Zayed Masjid in Abu Dhabi is far more beautiful.
More