Does red alert 3 require pixel shader 3.0

NO it doesn't you can Run red alert 3 with graphic card supporting pixel shader 2
and the shader settings can be applied from the game settings

the game will run perfectly fine but will Run on medium or low quality according to
Your graphic card capabilities .