Superusers can still connect to the new database, and there is no way to prevent them from doing so.
No other users can see the tables created in the new database, nor can they know the names of any of the objects.
The new database can be seen to exist by other users, and they can also see the name of the user who owns the database.