Overnight Stay at Paris Charles de Gaulle Airport
The airport operates 24 hours a day, so it's possible to sleep there. However, CDG is a very busy airport, and you definitely shouldn't expect an uninterrupted sleep. Besides noise and low temperatures, you'll also be bothered by bright lights that aren't dimmed at night and frequent airport announcements. If you spend the night in the public area, you probably won't be the only one seeking refuge there. In addition to travelers, homeless people also sleep at the Paris airport, so it's definitely better to stay in the areas beyond security control, where people without a boarding pass don't have access.
Although there is a so-called YOTELAIR (sleeping cabins) at the airport (T E2), given the price of 71£ (82 EUR) for 4 hours, it's not really worth it. It's more advantageous to use one of the hotels near the airport - you can find the 10 closest accommodations here.