In certain comic arcs, Spider-Man's identity is indeed exposed. This leads to various complications and challenges for him.
Spider-Man's identity has been revealed in the comics on multiple occasions. It often brings about significant changes in his relationships and the way he operates as a superhero.
Yes, it does happen in some storylines within the comics.