I was going thorough the definition of a manifold and needless to say it wasn't something that I could digest at one go. Then I saw the following Quora link and Qiaochu's illustrative answer.
It was great to see the motivation behind the concept of manifold. Then I looked at the definition of manifold that I have at my disposal which is the following:
A topological space $M$ is an $n$-dimensional real manifold if there is a family of subsets $U_\alpha$, $\alpha \in A$, of $\mathbb{R}^n$ and a quotient map $f \colon \coprod_\alpha U_\alpha \to M$ such that $f|_{U_\alpha}$ is a homeomorphism onto the image for all $\alpha$.
I understand that we are trying to conceptualize about a bigger space which when looked at a very small region looks like something else (a euclidean space) thereby giving a possibly incorrect bigger picture about the shape. Now what was the reason behind introducing disjoint union in this definition. Can someone help me to get in terms with this idea? I went through this related question and Samuel's brilliant answer to it.
Leaving aside the points about Haussdorff and second countable spaces I could draw that homeomorphism is the concept that we use to convey the similarity between two spaces. I can loosely convince myself that the existence of homeomorphism between two spaces means the similarity in the pattern of open sets in the two spaces. (I might not be expressing what I feel about it.) But still then can anyone make it a bit more elaborate as to why we use homeomorphism here? If we divided this bigger surface, let's say earth into smaller circles, then I can see that we wouldn't have gotten the local shape same everywhere, somewhere it would have been a circle and some other points it would have been an area in between four circles or maybe something else. But are these local shapes homeomorphic to $\mathbb{R}^2$? What are other shapes which wouldn't have been homeomorphic to $\mathbb{R}^2$?
I guess "What happens when two spaces are homeomorphic?" would be a good way to start the discussion.
"Being homeomorphic" is a very strong condition for spaces - it means that we have a bijection between the underlying sets of the spaces that is continuous, and whose inverse is continuous. In particular, you also get a bijection between the open sets of the two spaces.
We can therefore consider two spaces that are homeomorphic to be "essentially the same" for the purposes of topology.
So what goes wrong with your "Earth" analogy? I suspect when you say "circle" you mean "disc" (a circle is e.g. $\{x \in \mathbb R^2 \: | \: |x| = 1\}$ while a(n open) disc is e.g. $\{x \in \mathbb R^2 \: | \: |x| < 1\}$). Circles aren't open in the normal topology on a sphere, so we definitely want to be thinking about discs.
You say "some other points it would have been an area in between four [disks] or maybe something else" - this is true, but when dealing with a manifold we're always careful to make sure that the open disks we choose completely cover the manifold. This means that every point $p$ is contained in some $U_\alpha$.
I think part of the confusion is that the definition you've given isn't (to my mind) the most natural. In my opinion the nicest way to approach it is as follows: a manifold is a topological space $M$, and a collection of open sets $\{U_\alpha : \alpha \in A\}$ that cover $M$ (so given $p \in M$ we can find some $\alpha$ with $p \in U_\alpha$), and a corresponding collection $\{V_\alpha : \alpha \in A\}$ of open subsets of $\mathbb R^n$, and a collection of homeomorphisms $\phi_\alpha: U_\alpha \to V_\alpha$. (There are also the hypotheses about Hausdorff, second countable etc., but these aren't key for understanding the idea of a manifold.)
This definition is equivalent to the one you gave, but it makes it clearer that what we're caring about is that at every point $p$, the manifold $M$ locally looks like a subset of $\mathbb R^n$.
I'm not sure if that completely answers your questions, feel free to comment if there was something more specific that was confusing you.