Fire crews have been tackling a major incident after flooding hit parts of southwest Wales overnight, with people trapped in their homes and vehicles.