No. Tony Hawk: Ride (2009) requires the proprietary Ride Board Controller (infrared sensors + accelerometer board). The game does not accept DualShock 3 / Sixaxis input for gameplay.
The Ride board is a novelty peripheral; the core series plays far better on a standard controller.