No, Fargate strictly follows the CPU and memory limits you define in the ECS task definition. That's why it's mandated to mention CPU and memory to allocate the exact resources your container gets. If your container tries to use more CPU will be total memory overuse will cause the task to be killed.
So far gate won't autoscale as per the task. Scaling happens by only increasing the number of number of tasks.