As to being able to remarry. It normally takes 6 months from the date of service to the minimum time someone can get remarried if divorcing in California.
As to support - depends on your respective income levels, ability to earn etc. Assuming you've been a stay at home mom for 27 years and he has been the breadwinner, then most likely you'll get support.
If support is in the context of punishment for cheating, the cheating has no bearing on whether you get support.
Good luck with your situation and remember the above is general information and not specific advice regarding your case.
Sign up to receive a 10-part series of useful information and legal advice about the divorce process.