Note this is a hard problem, which depends on so many factors. Ergo giving complete answers which go through all the possibilities is a bit hard. For instance, the case changes dramatically depending on where you attach the pinpoint on Earth(i.e. north pole or equator) or whether Moon is in its apogee or perigee or somewhere else of its orbit. I will write some raw thoughts and give some rough numbers. I think actual computer simulations are needed for more detailed answers.
Qualitative Facts:
- When we attach the string, if Moon is in its apogee the destruction will obviously be minimum.
- Since Earth and Moon are (almost)sphere's, due to Moon's orbit inclination and its axis tilt; the string will wrap around Earth a finite number of times. I will try to estimate it in the next section.
- Even if the string initially wraps around the Earth, due to the constant torque applied on Earth, Earth's rotation will slow down and the string will eventually unwrap.
- Although Earth and Moon won't collide the changes in tidal forces and daytime length will be dramatic.
- The changes in Earth's period around Sun(year) will be negligible.
- The string's maneuver on Earth will change(at most half of) Earth's face considerably in short terms.
- The string's tension can presumably affect tectonic plates movements(continental drift) and cause severe earthquakes.
- Depending on where we attach the string, it will also change Earth's axis of rotation; i.e. the equator and the Pole Star will change.
Quantitative Estimations:
These are estimations which can presumably be made on the back of a cocktail napkin.
- How many times will the rope wrap around Earth?
Or equivalently, what will be the length of the tangled rope around Earth?
The mean inclination of the lunar orbit to the ecliptic plane is $\theta = 5.145°$. Therefore, the rope will only wrap a finite number of times around Earth. Assuming the pinpoint to be on Equator, I will find an upper limit and a lower limit, then take their geometrical mean as a reasonable guess (A valid technique in Fermi problems)for the amount of string wrapped around earth. The upper limit comes from wrapping a rope around a cylinder of radius and height $R_E$.
$$d_{up}= \frac{R_E}{\sin{\theta}} \approx 11 R_E \approx 7.1 \times 10^{7} \text{m}$$
The lower limit is basically half of equator's length:
$$d_{down}=\pi R_E \approx 2.0 \times 10^7 \text{m}$$
$$d \approx \sqrt{d_{up}d_{down}} = \sqrt{11 \pi}R_E \approx 5.9 R_E \approx 3.8 \times 10^7 \text{m}$$
i.e. Moon will get about $10 \%$ closer.
- The new day: Or what will be the new definition of one hour!
After attaching Moon and Earth together, and after all the wobbly motions settle down and the system reaches its steady routine motion again (the rope is no longer wrapped around Earth); Moon will be again in its initial distance from Earth; however, Earth and Moon will be rotating with the same angular velocity $\omega$. We can estimate this by conservation of Momentum. The answer may depend on whether we attach the string at Moon's apogee or perigee, so I will estimate both cases.
The initial angular momentum around system's center of mass, will be(ignoring axial tilt):
$$L=\frac{2}{5}M_E {R_E}^2 \omega_E + M_E {r_E}^2 \Omega + \frac{2}{5}M_M {R_M}^2 \omega_M + M_M {r_M}^2 \Omega$$
where $M_E$ and $M_M$, $R_E$ and $R_M$, $r_E$ and $r_M$, $\omega_E$ and $\omega_M$ are Earth and Moon's mass, radius, distance to COM and angular frequency around themselves respectively. But we know:
$$\omega_M = \Omega \\ M_E r_E = M_M r_M$$
$$\Rightarrow L=\frac{2}{5}M_E {R_E}^2 \omega_E + M_M \Omega \left( \frac{2}{5}R_M^2 + r_M(r_M + r_E)\right) \\ \approx \frac{2}{5}M_E {R_E}^2 \omega_E + M_M \Omega \left( r_M^2 \right) $$
Writing the angular momentum afterwards:
$$L=\frac{2}{5}M_E {R_E}^2 \Omega' + M_E {r_E}^2 \Omega' + \frac{2}{5}M_M {R_M}^2 \Omega' + M_M {r_M}^2 \Omega' \\ \approx \left( \frac{2}{5}M_E {R_E}^2 + M_M r_M^2\right) \Omega'$$
$$T'=\frac{2 \pi}{\Omega'} \approx \frac{2\pi \left( \frac{2}{5}M_E {R_E}^2 + M_M r_M^2 \right)}{\frac{2}{5}M_E {R_E}^2 \omega_E + M_M \Omega r_M^2 } = \frac{2 \pi}{\omega_E} \frac{\frac{2}{5} \frac{M_E}{M_M}+\left(\frac{r_M}{R_E} \right)^2}{\frac{2}{5} \frac{M_E}{M_M}+\left(\frac{r_M}{R_E} \right)^2 \frac{\Omega}{\omega_E}}$$
Taking the values from here and here and here, we'll get:
$$T' \approx 22.1 \text{day}$$
Which is really long. For perigee and apogee, the day-times will respectively be:
$$T'_{p}=21.6 \text{day} \\ T'_{a}=22.5 \text{day}$$ The difference is not that significant though.
To be completed