Lightweight gypsum board product and method of manufacture